Percona Toolkit is a collection of battle-tested command-line tools for MySQL and MariaDB that help diagnose performance, verify integrity, and perform online maintenance safely. Utilities such as pt-query-digest analyze slow logs and packet captures to surface hotspots and regressions, while pt-online-schema-change applies ALTERs with minimal blocking by copying and swapping tables. Consistency tools like pt-table-checksum and pt-table-sync detect and reconcile replication drift across replicas or shards. Other helpers find duplicate indexes, unused keys, skewed data distributions, and configuration issues that quietly erode performance. Each tool favors guardrails: dry runs, throttling, and resumable operations reduce the risk of harming production workloads. Operators and DBAs rely on the toolkit to bring observability and predictability to busy database fleets without hand-rolled scripts.
Features
- Tools for analyzing and diagnosing replication lag, deadlocks, and slow queries
- Utilities for archiving rows and finding duplicate indexes efficiently
- Can compare configurations and server variables across hosts (pt-config-diff)
- Supports profiling and summarizing MySQL, MariaDB, MongoDB, or PostgreSQL servers
- Collects system and query-level diagnostics for troubleshooting purposes
- Works with both configurations via CLI and files mirroring MySQL conventions
Project Samples
