Challenges of Efficiently Using MySQL on Modern Hardware

on YouTube ↗44m

" summary

Covers performance issues when running MySQL on modern server hardware and workloads, naming MySQL and Percona Server as the technologies. Explains typical bottlenecks caused by legacy implementation choices, discusses MySQL configuration for high-load systems, and outlines performance fixes expected in future MySQL and Percona Server releases.

AI-written summary · about

" chapters (14)

1. 0:00Introduction
2. 1:10MySQL history
3. 2:55MySQL on modern hardware
4. 4:43MySQL malloc issues
5. 7:37Buffer pool tuning
6. 13:12NUMA architecture impact
7. 20:48Table deletion problems
8. 23:43Buffer pool mutexes
9. 28:12MVCC high-load issues
10. 33:41Index cache problems
11. 35:47Index lock contention
12. 37:17Redo log issues
13. 39:09MySQL single-thread performance
14. 40:59Q&A

" related talks

• 54mPerformance Analysis and Optimization of MySQLPetr Zaytsev · HighLoad++ 2013
• 57mPerformance Analysis and Optimization of MySQLPetr Zaytsev · HighLoad++ 2013
• 01h 00mMySQL: a checklist for the high-load newcomerSveta Smirnova, Anastasiya Raspopina · РИТ++ 2017
• 53mEfficient MySQL PerformanceDaniel Nichter · Percona Live 2022
• 49mHighLoad Solutions On MySQLXiaobin Lin · HighLoad++ 2015
• 49m18 Ways to Fix MySQL BottlenecksPetr Zaytsev · Highload fwdays'20
• 43mOptimizing MySQL without SQL or touching my.cnfPeter Boros, Maxim Bublis · Percona Live Open Source Database Conference 2017
• 53mMySQL DevOpsV. Fedorkov, A. Raspopina · DevOps Pro Moscow 2019