MySQL Bottleneck Hunters – How Schooner Increased MySQL Performance by 8x

Jeremy Cole (Twitter)
Products & Services
Location: E142
Average rating: ****.
(4.00, 1 rating)

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

Photo of Jeremy Cole

Jeremy Cole

Twitter

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.

Comments

Picture of Shirley  Bailes
Shirley Bailes
07/26/2010 12:44pm PDT

@Michael…Jeremy provided the PDF and it is available now at the top of this page.

Michael Stack
07/26/2010 9:23am PDT

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

  • Intel
  • Microsoft
  • Google
  • Facebook
  • Rackspace Hosting
  • (mt) Media Temple, Inc.
  • ActiveState
  • CommonPlaces
  • DB Relay
  • FireHost
  • GoDaddy
  • HP
  • HTSQL by Prometheus Research
  • Impetus Technologies Inc.
  • Infobright, Inc
  • JasperSoft
  • Kaltura
  • Marvell
  • Mashery
  • NorthScale, Inc.
  • Open Invention Network
  • OpSource
  • Oracle
  • Parallels
  • PayPal
  • Percona
  • Qualcomm Innovation Center, Inc.
  • Rhomobile
  • Schooner Information Technology
  • Silicon Mechanics
  • SourceGear
  • Symbian
  • VoltDB
  • WSO2
  • Linux Pro Magazine

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