执行 pt-query-digest slow.log > digest.log 命令时报错:
[root@CentOS-CLI-MySql data]# pt-query-digest slow.log > digest.log
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/local/toolkit/bin/pt-query-digest line 75.
BEGIN failed--compilation aborted at /usr/local/toolkit/bin/pt-query-digest line 75.
原因是:缺少 Data-Dumper-2.154.tar.gz这个包,直接下载安装就ok了
wget http://www.cpan.org/modules/by-module/Data/Data-Dumper-2.154.tar.gz
tar xvzf Data-Dumper-2.154.tar.gz
cd Data-Dumper-2.121
perl Makefile.PL
make
make install
本文介绍了解决使用pt-query-digest工具处理慢查询日志时遇到的错误方法。错误原因是缺少Data::Dumper模块,通过下载并安装Data-Dumper-2.154.tar.gz包成功解决了该问题。
1729

被折叠的 条评论
为什么被折叠?



