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

Percona Toolkit Screenshot 1

Project Activity

See All Activity >

Categories

Command Line Tools

License

GNU General Public License version 3.0 (GPLv3)

Follow Percona Toolkit

Percona Toolkit Web Site

Other Useful Business Software
The All-in-One Commerce Platform for Businesses - Shopify Icon
The All-in-One Commerce Platform for Businesses - Shopify

Shopify offers plans for anyone that wants to sell products online and build an ecommerce store, small to mid-sized businesses as well as enterprise

Shopify is a leading all-in-one commerce platform that enables businesses to start, build, and grow their online and physical stores. It offers tools to create customized websites, manage inventory, process payments, and sell across multiple channels including online, in-person, wholesale, and global markets. The platform includes integrated marketing tools, analytics, and customer engagement features to help merchants reach and retain customers. Shopify supports thousands of third-party apps and offers developer-friendly APIs for custom solutions. With world-class checkout technology, Shopify powers over 150 million high-intent shoppers worldwide. Its reliable, scalable infrastructure ensures fast performance and seamless operations at any business size.
Learn More
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of Percona Toolkit!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Programming Language

Perl

Related Categories

Perl Command Line Tools

Registered

2025-09-10
Report inappropriate content