Diagnosing Database Issues With MySQL 8.0’s Performance Schema
summary
MySQL 8.0 adds concrete fields and a new histogram dataset so engineers can measure actual behavior: new columns include 95/99/9.99 quantiles and a sum of CPU time, sampling stores query samples with literals, and a new histogram_by_digest buckets table ties back to summary_by_digest. Code examples show how to capture and join these tables, timers record pico‑second ranges, sampling is off by default and has overhead, and histograms let you compute exact percentages meeting SLOs (one demo shows ~13% above 100ms).
AI-written summary · about
chapters (9)
- 0:00Introduction
- 4:28What do we care about
- 10:29Summary tables
- 17:53New columns
- 19:20CPU time
- 23:55Query samples
- 30:17New tables
- 40:57Troubleshooting
- 48:13Questions
related talks
27mMySQL 8 Observability
35mMySQL Indexes and Histograms to Speed Up Your Queries
45mHistograms in MySQL and MariaDB
24mMySQL Performance Schema
42mOMG MySQL 8.0 is out! Are we there yet?
29mMySQL Performance Schema : A great insight of running MySQL server
55mMySQL 8.0: Not Only Good, it's GREAT
43mUsing MySQL Performance Schema to debug performance issues