MySQL Performance Schema : A great insight of running MySQL server
summary
MySQL Performance Schema: monitoring feature in MySQL (including MySQL 5.7 GA) that collects low‑level runtime performance and session data with minimal overhead. The talk covers which statistics and summary tables Performance Schema provides, how to configure it manually or automatically to capture the data you need, and real-world use cases showing using those tables to monitor, troubleshoot and trace issues back to source files and lines of code.
AI-written summary · about
chapters (8)
- 0:00Start
- 0:27Program Agenda
- 2:42MySQL 5.7 Performance Schema: Design
- 5:24Instruments contd
- 6:46Statistics Tables in Performance Schema
- 13:12Use case 1
- 15:24Use case 3
- 17:06Event Hierarchy
related talks
24mMySQL Performance Schema
43mUsing MySQL Performance Schema to debug performance issues
50mDiagnosing Database Issues With MySQL 8.0’s Performance Schema
57mMariaDB 10.5 Tutorial - New Features for Troubleshooting
19mMariaDB Observability
27mMySQL 8 Observability
49mMySQL monitoring and debugging: maximum insight with minimal cost
57mPerformance Analysis and Optimization of MySQL