MySQL Bottleneck Hunters – How Schooner Increased MySQL Performance by 8x
MySQL users have an insatiable need for speed, capacity, and availability, all at a reasonable cost. This session will provide technical overview of the approach that Schooner engineering took to optimize MySQL Enterprise and InnoDB with flash memory, multi-core processors, and DRAM to achieve an 8x improvement in performance relative to existing systems.
This session will provide a crash course in the performance tuning tools and techniques that Schooner used to radically improve MySQL performance on commodity hardware. It will also offer an overview of the results that were achieved, and compare these results to other commonly deployed MySQL server architectures, including stock MySQL on SSDs and Fusion-io, using the industry-standard DBT2 benchmark.
Sponsored by Schooner Information Technology
Presentation
People planning to attend this session also want to see:
Jeremy Cole
Jeremy Cole is a long time MySQL Geek and pioneer of MySQL scalability. Jeremy started his MySQL adventure ten years ago as the fourteenth employee of a startup: MySQL AB. His initial work was primarily on documentation and core development, soon transitioning into support, and finally running the training and consulting organization during his four and a half years there. After MySQL, Jeremy coined the “MySQL Geek” title at Yahoo!, supporting hundreds of internal users of MySQL and many thousands of MySQL servers within Yahoo!’s infrastructure, as well as building a large team of MySQL experts around the world. Jeremy went on to found one of the premier MySQL consulting companies, Proven Scaling, which during its more than three years of operation provided detailed advice, optimization, new tools, and hands-on DBA and emergency support to more than 100 influential companies. As a MySQL Geek and Customer Advocate at Schooner Information Technology, Jeremy helps guide the vision, development, and ongoing customer support of Schooner’s data storage appliances.
Comments on this page are now closed.
Sponsorship Opportunities
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com
Download the OSCON Sponsor/Exhibitor Prospectus
Media Partner Opportunities
Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com
Press and Media
For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com
OSCON Newsletter
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the OSCON Newsletter (login required)
OSCON 2.0 Ideas
Have an idea for OSCON to share? oscon-idea@oreilly.com
Contact Us
View a complete list of OSCON contacts
O'Reilly Home | Privacy Policy | Contact Us | Sitemap | conf-webmaster@oreilly.com
© 2010, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938
Comments
@Michael…Jeremy provided the PDF and it is available now at the top of this page.
Jeremy,
I enjoyed the talk. Would you mind posting your slides? I’m interested in some of the details on the profiling tools you talked about, and the pitfalls of relying on the OS-reported IO usage on multi-core machines.
Thanks,
Michael