Resolving MySQL Problems Quickly
summary
Shows concrete fixes and diagnostics: use Percona Toolkit tools like pt-stalk and pt-query-digest to capture TCP dumps, slowlog extended stats and session counters, and profile queries; identify a MyISAM update causing two‑second locks, a temporary table of ~2 million rows producing ~30 million index reads, and 420 ms disk wait spikes; find binary‑log deletions of 1 GB on ext3 blocking the lock mutex and resolve by switching to xfs or smaller binlog sizes; proves fixes with per‑request instrumentation and PTX/PT- tools.
AI-written summary · about
chapters (30)
- 0:00Start
- 0:33Resolving MySQL Problems Quickly
- 1:39The Problem
- 6:48Following the flow
- 7:39My analysis
- 10:42Related Concepts
- 11:24What is important...
- 15:21Available Instrumentation Tools
- 16:12Slow Query
- 17:42EXPLAIN
- 20:09SESSION STATUS
- 23:46SHOW PROFILES
- 29:02Global Performance Problems
- 30:30MySQL Connections
- 31:06MySQL Replication
- 31:36MySQL Temporary Objects
- 32:51MySQL Query Response Time
- 33:56pt-mext
- 36:15Disk Subsystem Statistics
- 37:19pt-diskstats
- 37:35Optimizing Queries
- 37:59Enhanced Slow Log Statistics
- 39:24Diagnosing Intermittent Problems
- 39:54The Diagnostic Trigger
- 40:29Configuring pt-stalk
- 40:42Capturing Data
- 40:58Using pt-sift
- 41:24The Usual Suspects
- 43:59High Transaction Locking
- 44:29Filesystem Cache Issue
related talks
28mStay ahead of MySQL operational problems with Percona Toolkit and PMP plugins
41mMySQL Query Optimization Best Practices and Indexing
55mLet's Talk About MySQL Query Tuning
01h 02mHow-to MySQL Performance Diagnostic Using Percona PMM
28mBecoming a DBA for 5 minutes a day, the most important things to know for sysadmins and developers
33m7 or so deadly MySQL performance sins
49m18 Ways to Fix MySQL Bottlenecks
34mMySQL and InnoDB Performance for the Rest of Us