Introduction to MySQL Performance Tuning - workshop 1hr
summary
Covers concrete tuning moves: use MySQL Workbench performance reports and the performance_schema/sys schema to find heavy queries (statements aggregated by digest), enable innodb_monitoring, and watch the redo log usage (example shows a 47% used watermark that can trigger heavy checkpointing). Recommend primary keys, set innodb_buffer_pool_size ≈80% of free RAM on dedicated hosts, disable the query cache, keep per-connection buffers small, and prefer noop/deadline I/O schedulers or jemalloc/tcmalloc for better real-world throughput.
AI-written summary · about
chapters (5)
- 0:00Best practices and monitoring
- 21:56Initial configuration
- 28:07Buffer pools and redo logs
- 31:39Consistency and system stacks
- 49:30Conclusion and Q&A
related talks
56mOptimization Techniques in MySQL
55mLet's Talk About MySQL Query Tuning
53mMySQL DevOps
57mPerformance Analysis and Optimization of MySQL
54mPerformance Analysis and Optimization of MySQL
34mMySQL and InnoDB Performance for the Rest of Us
47mThe Low Hanging Fruits of MySQL
49m18 Ways to Fix MySQL Bottlenecks