MySQL monitoring and debugging: maximum insight with minimal cost
summary
Covers practical monitoring and debugging options for MySQL-based systems, naming built-in MySQL features, Percona Server extensions, and external tools. Explains which metrics (error logs, query timing, OS/hardware performance) are essential versus optional and when to enable them, emphasizing trade-offs between information collected and the monitoring overhead on performance.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 2:12Monitoring cost testing
- 7:40Why monitoring costs
- 17:52Minimal monitoring
- 23:15Query optimization
- 27:17App diagnostics
- 30:51Handling unexpected behavior
- 34:26Q&A
related talks
54mPerformance Analysis and Optimization of MySQL
44mPractical MySQL Optimization: Measure to Speed Up
53mMySQL DevOps
35mBest Practices for MySQL Performance
57mPerformance Analysis and Optimization of MySQL
53mIntroduction to MySQL Performance Tuning - workshop 1hr
19mMariaDB Observability
43mMySQL Like We Don't Know It