Diagnosing and Fixing MySQL Performance Problems

Location: Ballroom D
Average rating: ****.
(4.50, 8 ratings)

The typical trial-and-error approach to diagnosing and solving performance problems breaks down when the problems are difficult. As the complexity of the problem increases, so does the need for a methodical approach and powerful tools. This tutorial will teach you how to be systematic.

We’ll run through the process and then emphasize getting to know your toolkit, including iostat, vmstat & mk-query-digest. You will learn the approach Percona consultants have put to use across thousands of customer machines.

We’re going to try and teach you to be as practical as possible, with only minimal emphasis on performance theory where it’s needed. The main focus will be on MySQL versions 5.0, 5.1 and XtraDB on Linux operating systems.

Photo of Justin Swanhart

Justin Swanhart


Justin Swanhart is a Principal Consultant at Percona, where he helps customers architect large-scale systems. He also delivers training courses. Justin is the author of Flexviews and other open-source projects for MySQL.

Photo of Ryan Lowe

Ryan Lowe


Ryan Lowe is a high performance consultant for Percona, where he advises clients on performance and scaleability best practices for a variety of application architectures. In his free time, he likes to blog, play with agent-based simulation models and travel the world.

Photo of Baron Schwartz

Baron Schwartz


Baron Schwartz is the Chief Performance Architect at Percona. He is the lead author of High Performance MySQL, and creator of Maatkit.

Comments on this page are now closed.


Ying Littman
04/22/2011 7:45am PDT

Thanks Justin!

Picture of Justin Swanhart
Justin Swanhart
04/22/2011 7:29am PDT
Ying Littman
04/22/2011 4:14am PDT

This is a very useful session for me. I am looking for the slides. Would you please post it? You mentioned that you would do it during the session but I am not finding it on en.oreilly.com/mysql2011/pu.... Thanks much!

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts