Practical MySQL Optimization: Measure to Speed Up
summary
Covers practical performance optimization techniques for MySQL, focusing on measurement-driven tuning (measure to speed up). Describes concrete methods and tools for identifying bottlenecks and optimizing queries, configuration, and server behavior; approaches are largely applicable to other databases as well.
AI-written summary · about
chapters (16)
- 0:00Introduction
- 3:28App performance matters
- 7:07Response time key metric
- 13:48When to stop optimizing
- 14:10MySQL query handling
- 16:17Query and resource optimization
- 21:21Query analysis and future
- 25:17Schema optimization
- 27:43System optimization approaches
- 29:05Infrastructure and hardware
- 33:23Memory and storage
- 34:50Network and latency
- 36:44OS and filesystem
- 37:46MySQL versions and config
- 40:16Processes and monitoring
- 43:07Conclusion
related talks
54mPerformance Analysis and Optimization of MySQL
57mPerformance Analysis and Optimization of MySQL
53mIntroduction to MySQL Performance Tuning - workshop 1hr
41mMySQL Performance for DevOps
49mMySQL monitoring and debugging: maximum insight with minimal cost
53mEfficient MySQL Performance
55mLet's Talk About MySQL Query Tuning
53mMySQL DevOps