Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

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.

Subscriber Reviews

Average Rating: 4.285714285714286 out of 5 rating Based on 7 Ratings

"Good stuff" - by phluks on 07-MAY-2011
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
As a programmer I have mostly worried about query optimization. These guys take a much more holistic approach to diagnosing MySql. I like it.
Report as Inappropriate

"mr" - by kejau touray on 01-AUG-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
the second video's sound does not work
Report as Inappropriate

Table of Contents

Chapter/Selection

Time

Diagnosing and Fixing MySQL Performance Problems Part 1

Play Video

00:51:46

Diagnosing and Fixing MySQL Performance Problems Part 2

Preview

01:11:59

Diagnosing and Fixing MySQL Performance Problems Part 3

Preview

00:57:19

Extras

The publisher has provided additional content related to this title.


Description
Content

Visit the errata page for Diagnosing and Fixing MySQL Performance Problems

  • Errata

Visit the catalog page for Diagnosing and Fixing MySQL Performance Problems

  • Catalog Page