Network
Join Attendee Network
 
SOLD OUT

Diagnosing and Fixing MySQL Performance Problems

Baron Schwartz (VividCortex Inc), Morgan Tocker (Percona, Inc.)
8:30am Monday, 04/12/2010
Architecture and Technology, Performance Tuning and Benchmarking, Security and Database Administration, Tutorial
 Location: Ballroom G
Presentation: Diagnosing and Fixing MySQL Performance Problems Presentation [PDF]
Average rating: ****.
(4.33, 18 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. Attendees are encouraged to bring laptops as there will be some interactive components.

People planning to attend this session also want to see:

Photo of Baron Schwartz

Baron Schwartz

VividCortex Inc

Baron is co-founder and CTO of VividCortex, a provider of SaaS database administration tools. He is the lead author of High Performance MySQL and continues to research and publish under the O’Reilly imprint. He has created several open-source software tools, including Maatkit, and has authored features for MySQL and InnoDB. He is an Oracle ACE, and the founder of the worldwide OpenSQL Camp conference series. He holds a degree in Computer Science from the University of Virginia. Baron lives in Charlottesville, Virginia with his family.

Photo of Morgan Tocker

Morgan Tocker

Percona, Inc.

Morgan is the Director of Training at Percona, Inc. His interests in MySQL include Performance Tuning, scalability and High Availability. He is a regular speaker on these topics in the United States and Canada.

Before joining Percona, Morgan worked as a Technical Instructor for MySQL (and then Sun Microsystems) in Canada where he taught courses on High Availability, Performance Tuning and Database Administration. He has also previously worked in the MySQL Support Team, and enjoyed a brief stint as a Rails developer for social finance website SmartHippo.com.

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

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

Download the O'Reilly MySQL Conference & Expo 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

O'Reilly MySQL Conference Newsletter

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

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.