Using MySQL Performance Schema to debug performance issues

on YouTube ↗43m

" summary

Shows how to use MySQL Performance Schema to investigate and debug database performance problems by collecting and analyzing its instrumentation data; demonstrates which Performance Schema tables and metrics to query and how to interpret them to find hotspots like slow queries, waits, and resource contention; covers practical usage techniques for turning Performance Schema output into actionable fixes.

AI-written summary · about

" chapters (5)

1. 0:00Start
2. 10:25Implementation
3. 16:28Instruments
4. 21:16What are top wait events in my server?
5. 36:57Summary. Cons.

" related talks

• 29mMySQL Performance Schema : A great insight of running MySQL serverMayank Prasad · FOSSASIA Summit 2017
• 24mMySQL Performance SchemaMayank Prasad · FOSSASIA 2015 DevOps Track
• 57mMariaDB 10.5 Tutorial - New Features for TroubleshootingValerii Kravchuk · Percona Live Online 2020
• 50mDiagnosing Database Issues With MySQL 8.0’s Performance SchemaRobert Mandeville · Percona Live 2022
• 54mPerformance Analysis and Optimization of MySQLPetr Zaytsev · HighLoad++ 2013
• 57mPerformance Analysis and Optimization of MySQLPetr Zaytsev · HighLoad++ 2013
• 19mMariaDB ObservabilityPeter Zaitsev · FOSDEM 2021
• 44mPractical MySQL Optimization: Measure to Speed UpPetr Zaytsev · HighLoad++ 2015