安装​​percona-toolkit​​步骤

1. 下载​​percona-toolkit​​ 包

官网下载即可。链接: ​​https://www.percona.com/downloads/percona-toolkit/LATEST/​

2. 安装依赖


  • ​yum install perl-DBI​
  • ​yum install perl-DBD-MySQL​
  • ​yum install perl-Time-HiRes​
  • ​yum install perl-IO-Socket-SSL​​ 如果安装过程中出现如下错误:

Error: Package: perl-DBD-MySQL-4.023-6.el7.x86_64 (base)
Requires: libmysqlclient.so.18()(64bit)
Error: Package: perl-DBD-MySQL-4.023-6.el7.x86_64 (base)
Requires: libmysqlclient.so.18(libmysqlclient_18)(64bit)
Error: Package: 2:postfix-2.10.1-6.el7.x86_64 (@anaconda)
Requires: libmysqlclient.so.18()(64bit)
Error: Package: 2:postfix-2.10.1-6.el7.x86_64 (@anaconda)
Requires: libmysqlclient.so.18(libmysqlclient_18)(64bit)
You could try using --skip-broken to work around the problem
** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows:
2:postfix-2.10.1-6.el7.x86_64 has missing requires of libmysqlclient.so.18()(64bit)
2:postfix-2.10.1-6.el7.x86_64 has missing requires of libmysqlclient.so.18(libmysqlclient_18)(64bit)

则是有依赖包没有安装,去mysql 官网下载一个即可。

接着安装​​percona-toolkit​​。接着报错

[root@server4 mysql]# rpm -ivh percona-toolkit-3.0.12-1.el7.x86_64.rpm
warning: percona-toolkit-3.0.12-1.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
perl(Digest::MD5) is needed by percona-toolkit-3.0.12-1.el7.x86_64

则需要执行如下命令:

yum -y install perl-Digest-MD5

最后安装​​percona-toolkit​

[root@server4 mysql]# rpm -ivh percona-toolkit-3.0.12-1.el7.x86_64.rpm
warning: percona-toolkit-3.0.12-1.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:percona-toolkit-3.0.12-1.el7 ################################# [100%]