percona-toolkit工具安装
1.yum安装
yum install perl-TermReadKey.x86_64
yum install perl-IO-Socket-SSL
yum install perl-DBI.x86_64
yum install perl-DBD-MySQL.x86_64
yum install percona-toolkit-2.2.16
2.rpm安装
# wget https://www.percona.com/downloads/percona-toolkit/2.2.17/RPM/percona-toolkit-2.2.17-1.noarch.rpm
# rpm -ivh percona-toolkit-2.2.17-1.noarch.rpm
warning: percona-toolkit-2.2.17-1.noarch.rpm: Header V4 DSA signature: NOKEY, key ID cd2efd2a
error: Failed dependencies:
perl(DBI) >= 1.13 is needed by percona-toolkit-2.2.17-1.noarch
perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.17-1.noarch
perl(IO::Socket::SSL) is needed by percona-toolkit-2.2.17-1.noarch
# wget http://pkgs.repoforge.org/perl-DBI/perl-DBI-1.622-1.el5.rfx.x86_64.rpm
# wget http://pkgs.repoforge.org/perl-DBD-MySQL/perl-DBD-MySQL-4.022-1.el5.rfx.x86_64.rpm
# wget http://pkgs.repoforge.org/perl-IO-Socket-SSL/perl-IO-Socket-SSL-1.44-1.el5.rfx.noarch.rpm
# rpm -ivh perl-DBI-1.622-1.el5.rfx.x86_64.rpm
# rpm -ivh perl-DBD-MySQL-4.022-1.el5.rfx.x86_64.rpm
warning: perl-DBD-MySQL-4.022-1.el5.rfx.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 6b8d79e6
error: Failed dependencies:
libmysqlclient.so.15()(64bit) is needed by perl-DBD-MySQL-4.022-1.el5.rfx.x86_64
libmysqlclient.so.15(libmysqlclient_15)(64bit) is needed by perl-DBD-MySQL-4.022-1.el5.rfx.x86_64
mysql is needed by perl-DBD-MySQL-4.022-1.el5.rfx.x86_64
# rpm -ivh perl-IO-Socket-SSL-1.44-1.el5.rfx.noarch.rpm
warning: perl-IO-Socket-SSL-1.44-1.el5.rfx.noarch.rpm: Header V3 DSA signature: NOKEY, key ID 6b8d79e6
error: Failed dependencies:
perl(Net::SSLeay) >= 1.21 is needed by perl-IO-Socket-SSL-1.44-1.el5.rfx.noarch
# wget http://mirror.centos.org/centos/5/os/x86_64/CentOS/mysql-5.0.95-5.el5_9.x86_64.rpm
# wget http://pkgs.repoforge.org/perl-Net-SSLeay/perl-Net-SSLeay-1.36-1.el5.rfx.x86_64.rpm
# rpm -ivh mysql-5.0.95-5.el5_9.x86_64.rpm
# rpm -ivh perl-Net-SSLeay-1.36-1.el5.rfx.x86_64.rpm
# rpm -ivh perl-IO-Socket-SSL-1.44-1.el5.rfx.noarch.rpm
# rpm -ivh percona-toolkit-2.2.17-1.noarch.rpm
# rpm -ql percona-toolkit-2.2.17-1 | grep bin
/usr/bin/pt-align
/usr/bin/pt-archiver
/usr/bin/pt-config-diff
/usr/bin/pt-deadlock-logger
/usr/bin/pt-diskstats
/usr/bin/pt-duplicate-key-checker
/usr/bin/pt-fifo-split
/usr/bin/pt-find
/usr/bin/pt-fingerprint
/usr/bin/pt-fk-error-logger
/usr/bin/pt-heartbeat
/usr/bin/pt-index-usage
/usr/bin/pt-ioprofile
/usr/bin/pt-kill
/usr/bin/pt-mext
/usr/bin/pt-mysql-summary
/usr/bin/pt-online-schema-change
/usr/bin/pt-pmp
/usr/bin/pt-query-digest
/usr/bin/pt-show-grants
/usr/bin/pt-sift
/usr/bin/pt-slave-delay
/usr/bin/pt-slave-find
/usr/bin/pt-slave-restart
/usr/bin/pt-stalk
/usr/bin/pt-summary
/usr/bin/pt-table-checksum
/usr/bin/pt-table-sync
/usr/bin/pt-table-usage
/usr/bin/pt-upgrade
/usr/bin/pt-variable-advisor
/usr/bin/pt-visual-explain
