O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Diagnosing and Fixing MySQL Performance Problems

Video Description

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, and 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.