Yum Install Percona Toolkit (Maatkit)

You need the some tools for MySQL / MariaDb administration and Percona Toolkit (formerly Maatkit) is just the right tools for you. Here's how to install them,

1) Install the Repo.

For 64-bit: rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm

For 32-bit: rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.i386.rpm

2) Yum Install Percona Toolkit.

yum install percona-toolkit-2.2.5-2.noarch

3) Then use the tools as it is.

pt-agent
pt-duplicate-key-checker
pt-index-usage
pt-pmp
pt-slave-restart
pt-upgrade
pt-align
pt-fifo-split
pt-ioprofile
pt-query-digest
pt-stalk
pt-variable-advisor
pt-archiver
pt-find
pt-kill
pt-show-grants
pt-summary
pt-visual-explain
pt-config-diff
pt-fingerprint
pt-mext
pt-sift
pt-table-checksum
ptar
pt-deadlock-logger
pt-fk-error-logger
pt-mysql-summary
pt-slave-delay
pt-table-sync
ptardiff
pt-diskstats
pt-heartbeat
pt-online-schema-change
pt-slave-find
pt-table-usage
ptx

Usage info here and here.

Related Links:

• Related Links Widget for Blogspot