HTTP/2 302 server: nginx date: Sun, 03 Aug 2025 15:47:16 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20110830140316 location: https://web.archive.org/web/20110830140316/https://safari.oreilly.com/9781449396275 server-timing: captures_list;dur=0.700122, exclusion.robots;dur=0.035852, exclusion.robots.policy;dur=0.021363, esindex;dur=0.014236, cdx.remote;dur=107.788656, LoadShardBlock;dur=132.721441, PetaboxLoader3.datanode;dur=60.692525, PetaboxLoader3.resolve;dur=49.005780 x-app-server: wwwb-app217 x-ts: 302 x-tr: 271 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: wb-p-SERVER=wwwb-app217; path=/ x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 301 server: nginx date: Sun, 03 Aug 2025 15:47:16 GMT content-type: text/plain content-length: 0 x-archive-orig-content-length: 0 location: https://web.archive.org/web/20110830140316/https://my.safaribooksonline.com/9781449396275?portal=oreilly x-archive-orig-server: SWS + Microsoft-HTTPAPI/2.0 x-archive-orig-date: Tue, 30 Aug 2011 14:03:16 GMT x-archive-orig-connection: close x-archive-orig-set-cookie: Safari=cookieversion=2&cookie-monster=false&portal=oreilly&key=&sessionid=5ec58474-f4d5-48c0-bb96-a0cc187229e5&ref=Undefined&oref=%2f; Path=/; Domain=safari.oreilly.com x-archive-orig-set-cookie: cookie-monster=true; Path=/; Expires=Mon, 30 Aug 2021 14:03:16 GMT cache-control: max-age=1800 memento-datetime: Tue, 30 Aug 2011 14:03:16 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Thu, 21 Oct 2010 09:44:15 GMT", ; rel="prev memento"; datetime="Thu, 30 Jun 2011 05:13:43 GMT", ; rel="memento"; datetime="Tue, 30 Aug 2011 14:03:16 GMT", ; rel="last memento"; datetime="Tue, 30 Aug 2011 14:03:16 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: alexa-web-20110908003817-00023/52_23_20110830140306_crawl100.arc.gz server-timing: captures_list;dur=0.563167, exclusion.robots;dur=0.023236, exclusion.robots.policy;dur=0.011420, esindex;dur=0.012623, cdx.remote;dur=38.914142, LoadShardBlock;dur=354.037998, PetaboxLoader3.datanode;dur=195.868192, PetaboxLoader3.resolve;dur=213.258628, load_resource;dur=110.965008 x-app-server: wwwb-app217 x-ts: 301 x-tr: 531 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 302 server: nginx date: Sun, 03 Aug 2025 15:47:19 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20110812042518 location: https://web.archive.org/web/20110812042518/https://my.safaribooksonline.com/9781449396275?portal=oreilly server-timing: captures_list;dur=0.670576, exclusion.robots;dur=0.022653, exclusion.robots.policy;dur=0.009717, esindex;dur=0.013869, cdx.remote;dur=1427.491236, LoadShardBlock;dur=436.632369, PetaboxLoader3.datanode;dur=75.229965, PetaboxLoader3.resolve;dur=48.411075 x-app-server: wwwb-app217 x-ts: 302 x-tr: 1894 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Sun, 03 Aug 2025 15:47:20 GMT content-type: text/html; charset=utf-8 x-archive-orig-expires: Mon, 05 Apr 1970 03:12:07 GMT x-archive-orig-server: SWS + Microsoft-HTTPAPI/2.0 x-archive-orig-cache-control: private x-archive-orig-p3p: CP="CAO DSP COR LAW CUR ADMi DEVi PSAi IVAi IVDi CONo HISi TELo OUR IND UNI" x-archive-orig-date: Fri, 12 Aug 2011 04:25:19 GMT x-archive-orig-connection: close x-archive-orig-set-cookie: Safari=cookieversion=2&cookie-monster=false&portal=oreilly&key=&sessionid=894afa12-153a-49d9-99fb-3433aa92395f&ref=Undefined&oref=%2f; Path=/; Domain=my.safaribooksonline.com x-archive-orig-set-cookie: cookie-monster=true; Path=/; Expires=Thu, 12 Aug 2021 04:25:18 GMT x-archive-guessed-content-type: text/html x-archive-guessed-charset: utf-8 memento-datetime: Fri, 12 Aug 2011 04:25:18 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Fri, 12 Aug 2011 04:25:18 GMT", ; rel="memento"; datetime="Fri, 12 Aug 2011 04:25:18 GMT", ; rel="last memento"; datetime="Fri, 12 Aug 2011 04:25:18 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: WIDE-20110812032005-crawl416/WIDE-20110812040638-00215.warc.gz server-timing: captures_list;dur=0.631290, exclusion.robots;dur=0.021758, exclusion.robots.policy;dur=0.010712, esindex;dur=0.012187, cdx.remote;dur=268.406246, LoadShardBlock;dur=347.535703, PetaboxLoader3.datanode;dur=132.074952, PetaboxLoader3.resolve;dur=382.248452, load_resource;dur=241.172377 x-app-server: wwwb-app217 x-ts: 200 x-tr: 946 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip

Content Tabs

• Home
• Subscribe
• Free Trial

• Category Map
• My Quick Links
  • Books
  • Video
  • Rough Cuts
  • Short Cuts
  • Tools

Search:criteria:Entire SiteBook/Video TitlesShort CutsRough Cuts

Sign In

• 

• Diagnosing and Fixing MySQL Performance Problems

• By: Baron Schwartz; Morgan Tocker

• Publisher: O'Reilly Media, Inc.

• Pub. Date: July 06, 2010

• Running Time: 3 hours 1 minute 4 seconds

• Subscriber Rating: [4 Ratings] Subscriber Reviews

Diagnosing and Fixing MySQL Performance Problems

• Overview
• Table of Contents
• Extras
• Help

Subscriber Reviews • Browse Similar Topics

Overview

Top Video Titles

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:  Based on 4 Ratings

"Good stuff" - by phluks on 07-MAY-2011
Reviewer 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:
the second video's sound does not work
Report as Inappropriate

Browse Similar Topics

Top Level Categories:
Information Technology & Software Development
Product
Vendor

Sub-Categories:
Information Technology & Software Development > Databases
Databases > MySQL
Product > MySQL
Vendor > Oracle

Table of Contents

Chapter/Selection		Time
Diagnosing and Fixing MySQL Performance Problems Part 1 Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:51:46
Diagnosing and Fixing MySQL Performance Problems Part 2 Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		01:11:59
Diagnosing and Fixing MySQL Performance Problems Part 3 Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		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

---

About Safari Books Online • Terms of Service • Gift Subscriptions • Privacy Policy • Contact Us • Corporate Licenses • Help • Accessibility |

Copyright 2011Safari Books Online. All rights reserved.