Advanced Optimization and Troubleshooting MySQL Using PMM2
summary
Demonstrates PMM2’s actionable features: ClickHouse-backed query analytics surfaces a specific case where an UPDATE query spends 99% time on lock and lets operators drill to EXPLAIN and row‑count metrics, a custom cpu core score reveals a normalized CPU load 12 indicating single‑core saturation, dashboards import from grafana.com, and custom performance_schema collectors ship new metrics so memory and IO hotspots appear and correlate immediately.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 5:00Query Analytics
- 8:55Resource Usage
- 12:45Dashboards
- 16:20Red Red Methods
- 18:35Adhoc Filtering
- 23:45Memory Summary
related talks
27mUsing PMM to identify and troubleshoot problematic MySQL queries
01h 02mHow-to MySQL Performance Diagnostic Using Percona PMM
58mBetter MySQL With Percona PMM
38mAdvanced PMM Usage
30mWhy we recommend PMM to our clients
50mHow To Improve PostgreSQL Monitoring and Observability With PMM - Part 2
21mEasy way of application monitoring
41mMySQL Query Optimization Best Practices and Indexing