pt-query-digest Archives - ITFROMZERO

Enable MySQL Slow Query Log and Use pt-query-digest to Find Database Bottlenecks

By IT From Zero October 24, 2026

A guide to enabling MySQL Slow Query Log without restarting the server and using pt-query-digest to dissect and rank CPU-bottlenecking queries in production.

Database

Analyzing MySQL Slow Query Log with pt-query-digest: Pinpointing the Real Culprit Behind Database Slowdowns

By IT From Zero June 27, 2026

pt-query-digest from Percona Toolkit analyzes MySQL Slow Query Log by grouping and ranking queries by their performance impact. A step-by-step guide: enable logging, install the tool, read the report, and optimize real-world queries.