pt-query-digest安装
安装默认情况下直接使用pt-query-digest 命令会提示找不到该命令
pt-query-digest /var/lib/mysql/localhost-slow.log
下载安装工具
wget percona.com/get/pt-query-digest
授权执行权限
chmod u+x pt-query-digest
移动到/usr/bin/,根据实际情况调整
mv pt-query-digest /usr/bin/
报错执行以下脚本
Can’t locate Digest/MD5.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /usr/bin/pt-query-digest line 2494.
BEGIN failed–compilation aborted at /usr/bin/pt-query-digest line 2494.
解决办法:
执行安装perl-Digest-MD5的命令,如果能连上网,直接yum安装,如下:
yum -y install perl-Digest-MD5
在这里插入图片描述
Can’t locate Data/Dumper.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /usr/bin/pt-query-digest line 75.
BEGIN failed–compilation aborted at /usr/bin/pt-query-digest line 75.
yum install perl-DBI
验证是否成功
pt-query-digest --help
出现这个界面证明已经安装成功!!