mysql percona-toolkit_MySQL优化索引工具percona-toolkit简称pt安装使用

今天想安装个Percona Toolkit简称pt工具来优化

直接下载下来安装

wget https://www.percona.com/downloads/percona-toolkit/3.2.1/binary/redhat/6/x86_64/percona-toolkit-3.2.1-1.el6.x86_64.rpm

提示缺少依赖包

[root@hl-img-m software]# rpm -ivh ./percona-toolkit-3.2.1-1.el6.x86_64.rpm

warning: ./percona-toolkit-3.2.1-1.el6.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY

error: Failed dependencies:

perl(DBI) >= 1.13 is needed by percona-toolkit-3.2.1-1.el6.x86_64

perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-3.2.1-1.el6.x86_64

perl(IO::Socket::SSL) is needed by percona-toolkit-3.2.1-1.el6.x86_64

perl(Term::ReadKey) is needed by percona-toolkit-3.2.1-1.el6.x86_64

安装依赖包方式：

yum install perl-DBI perl-DBD-MySQL perl-Digest-MD5 perl-IO-Socket-SSL perl-TermReadKey

自动安装依赖包：

yum install -y percona-toolkit-3.2.1-1.el6.x86_64.rpm

成功；

看看使用

[root@hl-img-m software]# pt-duplicate-key-checker –user=root -password=root –socket=/tmp/mysql.sock

忘记不是在测试数据库上了，将就看看。