MySQL Performance: Demystified Tuning & Best Practices

This presentation covers most hot performance issues in MySQL 5.5, 5.6, and 5.7 related to scalability and high loads. Topics discussed include some initial design limitations in MySQL and InnoDB and their step-by-step improvements, remaining issues, current workarounds, final solutions, practical tuning, and more. And, of course, all presented materials are widely commented by benchmark results.