MySQL 8 Observability
summary
MySQL 8 adds concrete observability: Performance Schema with >1,000 instruments and configurable consumers, session vs global SHOW STATUS deltas, INFORMATION_SCHEMA/sys views for I/O and memory allocations, and sys schema summaries that expose surprising totals (eg many terabyte-like allocation counts that are actually allocation counts). Query tools include the new tree EXPLAIN format and EXPLAIN ANALYZE (executes and compares estimates), optimizer trace, extended slow log, and Percona Monitoring and Management for trending and drilldown; enable selectively to limit overhead.
AI-written summary · about
chapters (35)
- 0:00Intro
- 0:46MySQL 8 Data Sources
- 1:30Global And Session
- 2:42Status-Profiling Query
- 3:38With Percona Toolkit
- 4:06INFORMATION_SCHEMA
- 4:29INFORMATION SCHEMA - Metrics
- 4:50Note on Innodb Metrics While Looks similar to SHOW STATUS is not enabled by default
- 5:14Performance Shema
- 5:57Performance Schema Configuration mysql show tables like "setup!"
- 7:35What Objects to Instrument
- 8:16What Threads do we want to Instrument
- 8:29Example of Performance Schema Data
- 9:09Too Hard to Use ?
- 9:32Views for Humans
- 9:59Example for Humans
- 10:40Example for Machines
- 11:06Information by Client Hosts
- 13:34Statement Types Per Host
- 15:32Memory Allocation
- 16:15Enhanced Metrics Table
- 16:45Processlist - Includes Background
- 17:46Redundant Indexes
- 17:56Table Access Statistics
- 18:15Unused Indexes
- 18:40Are you using SSL ?
- 18:58Statements info
- 19:34Errors and Warnings?
- 20:51Slow Query Log (Percona Server)
- 21:18Basic Explain
- 21:36TREE Format (8.0.16+)
- 21:55EXPLAIN ANALYZE (8.0.18+)
- 22:41Percona Monitoring and Management
- 23:30System Monitoring
- 23:45MySQL Instance Summary
