18 Ways to Fix MySQL Bottlenecks
summary
Practical checklist of 18 concrete fixes for sudden MySQL performance spikes, including scaling the instance, adding read replicas and routing reads, and using a proxy/connection pool and query cache. Covers operational actions such as fitting the InnoDB buffer pool into RAM, moving heavy/nonessential features off the primary, inspecting CPU steal, IO latency and packet loss, adjusting file‑descriptor and swap limits, adding or removing indexes per EXPLAIN, tuning MySQL and OS parameters, archiving old data, and shifting background jobs to replicas.
AI-written summary · about
chapters (27)
- 0:00Introduction
- 1:13Fix bottlenecks
- 3:06Cloud scaling
- 5:46Read replicas
- 7:55Load balancing
- 10:55App optimization
- 12:49Resource hogs
- 15:06CPU bottlenecks
- 19:42Memory and storage
- 21:34Swap and virtual memory
- 24:25Process memory
- 26:12Disk tuning
- 27:15I/O diagnostics
- 30:05Network bottlenecks
- 33:05Latency and retransmits
- 34:30Query optimization
- 36:23Index management
- 38:14Performance settings
- 39:18OS tuning
- 40:27Data cleanup
- 41:09Table maintenance
- 42:16Background tasks
- 42:58Lock issues
- 44:33Config check
- 45:18Performance tips
- 46:02Q&A: failure diagnosis
- 47:49Q&A: binary log
related talks
33m7 or so deadly MySQL performance sins
53mMySQL DevOps
34mMySQL and InnoDB Performance for the Rest of Us
56mOptimization Techniques in MySQL
54mPerformance Analysis and Optimization of MySQL
47mThe Low Hanging Fruits of MySQL
25mMySQL Performance for DevOps
53mIntroduction to MySQL Performance Tuning - workshop 1hr