Percona Toolkit 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.

MySQL

Handling MySQL Replication Data Drift: Mastering Percona Toolkit with Zero Downtime

By IT From Zero August 23, 2026

Is your Master and Slave data out of sync even though Replication is running? Learn to use pt-table-checksum and pt-table-sync for online MySQL synchronization without downtime.

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.

MySQL

ALTER TABLE on Large MySQL Tables Without Downtime: A Guide to pt-online-schema-change

By IT From Zero May 15, 2026

Don't let ALTER TABLE crash your system. Learn how to use pt-online-schema-change to modify large MySQL tables safely, smoothly, and without downtime.