We’ve completed a significant upgrade to our video platform!

Still in development

Let us know what you think. We’d love your feedback.

x

Confirm Download

Simultaneous file downloading works best in FireFox, Chrome, and Safari browsers. Please keep this window open until all downloads are complete. Some customers prefer using download managers like GetThemAll Downloader for Chrome or DownThemAll! for Firefox.

Cancel Download

Diagnosing and Fixing MySQL Performance Problems

    • Diagnosing and Fixing MySQL Performance Problems Part 1  (Free)

      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.
    • 00:51:46

    • Diagnosing and Fixing MySQL Performance Problems Part 2

      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.
    • 01:11:59

    • Diagnosing and Fixing MySQL Performance Problems Part 3

      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.
    • 00:57:19

Diagnosing and Fixing MySQL Performance Problems

  • Publisher: O'Reilly Media
  • Released: July 2010
  • Run time: 3 hours 1 minutes

When it comes to diagnosing and solving performance problems with MySQL, the typical trial-and-error approach breaks down when the problems become truly difficult. As the complexity of the problem increases, so does the need for a methodical approach and powerful tools. In this video tutorial, two consultants with Percona -- the international company that specializes in MySQL -- will teach you how to be more systematic.

Baron Schwartz and Morgan Tocker start with an overview of the process, and then introduce the tools you need diagnose and fix your system, including iostat, vmstat and mk-query-digest. You'll learn the approach that Percona consultants have put to use across thousands of customer machines.

This tutorial is practical and hands-on, with only minimal emphasis on performance theory when needed. The emphasis of this video presentation will be on MySQL versions 5.0 and 5.1, as well as XtraDB on Linux operating systems.