pt-query-digest工具安装(用于分析slow_query_log)
cd /usr/bin/
wget percona.com/get/pt-query-digest
pt-query-digest /u01/mysqllog/slow.log > /u01/mysqllog/slow_repopt
-bash: /usr/bin/pt-query-digest: Permission denied 报没有权限
chmod +x pt-query-digest
pt-query-digest /u01/mysqllog/slow.log > /u01/mysqllog/slow_repopt
Can't locate Time/HiRes.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 3211.
BEGIN failed--compilation aborted at /usr/bin/pt-query-digest line 3211. 这里报错少包
yum install -y perl-DBI perl-Time-HiRes perl-DBD-MySQL perl-IO-Socket-SSL perl-Digest-MD5
cd /usr/bin/
wget percona.com/get/pt-query-digest
pt-query-digest /u01/mysqllog/slow.log > /u01/mysqllog/slow_repopt
-bash: /usr/bin/pt-query-digest: Permission denied 报没有权限
chmod +x pt-query-digest
pt-query-digest /u01/mysqllog/slow.log > /u01/mysqllog/slow_repopt
Can't locate Time/HiRes.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 3211.
BEGIN failed--compilation aborted at /usr/bin/pt-query-digest line 3211. 这里报错少包
yum install -y perl-DBI perl-Time-HiRes perl-DBD-MySQL perl-IO-Socket-SSL perl-Digest-MD5