Challenges of Using MySQL Efficiently on Modern Hardware

on YouTube ↗44m

" summary

Talk examines MySQL performance issues on modern server hardware and workloads, naming MySQL and Percona Server. It covers typical bottlenecks caused by legacy implementations, configuration strategies for high-load systems, and expected performance improvements in future MySQL/Percona releases.

AI-written summary · about

" chapters (19)

1. 0:00Introduction
2. 1:10MySQL history overview
3. 2:55Performance issues on modern hardware
4. 4:43malloc problems and jemalloc
5. 7:37Buffer pool problems
6. 12:50NUMA architecture and impact
7. 17:11NUMA fixes in Linux
8. 20:48Buffer pool table eviction
9. 23:43Global mutexes in buffer pool
10. 27:10Fixing global mutex issues
11. 28:12MVCC problems
12. 31:51MySQL 5.7 transaction tuning
13. 33:41Mutex problem detection
14. 35:04Index cache problems
15. 36:29Index block locking issues
16. 37:17Redo log problems
17. 38:47Redo log block size tuning
18. 39:31Low-load performance
19. 40:59Q&A

" related talks

• 57mPerformance Analysis and Optimization of MySQLPetr Zaytsev · HighLoad++ 2013
• 54mPerformance Analysis and Optimization of MySQLPetr Zaytsev · HighLoad++ 2013
• 01h 00mMySQL: a checklist for the high-load newcomerSveta Smirnova, Anastasiya Raspopina · РИТ++ 2017
• 49mHighLoad Solutions On MySQLXiaobin Lin · HighLoad++ 2015
• 43mOptimizing MySQL without SQL or touching my.cnfPeter Boros, Maxim Bublis · Percona Live Open Source Database Conference 2017
• 44mPractical MySQL Optimization: Measure to Speed UpPetr Zaytsev · HighLoad++ 2015
• 53mEfficient MySQL PerformanceDaniel Nichter · Percona Live 2022
• 53mIntroduction to MySQL Performance Tuning - workshop 1hrJesper Wisborg Krogh · FOSSASIA Summit 2017