npm

percona-toolkit

Advanced command-line tools for MySQL, MariaDB and system administration

brewmacoslinux

Try with needOr install directly

Source

About

Command-line tools for MySQL, MariaDB and system tasks

Commands

pt-query-digestpt-online-schema-changept-table-checksumpt-duplicate-key-checkerpt-findpt-heartbeatpt-killpt-deadlock-loggerpt-show-grantspt-config-diff

Examples

Analyze slow query logs to find problematic queries$ pt-query-digest /var/log/mysql/slow.log | head -20

Perform online schema changes without locking tables$ pt-online-schema-change --alter='ADD COLUMN status INT' D=mydb,t=mytable --execute

Check for duplicate indexes in a database$ pt-duplicate-key-checker --host=localhost --user=root --password=secret