Mysql 性能分析工具安装

环境

• centos7
• mysql5.7

mytop 安装

yum install yum-plugin-protectbase.noarch -y
yum install mytop -y

percona-toolkit安装

wget https://www.percona.com/downloads/percona-toolkit/3.2.1/binary/redhat/7/x86_64/percona-toolkit-3.2.1-1.el7.x86_64.rpm
yum install perl-DBI
yum install perl-DBD-MySQL
yum install perl-IO-Socket-SSL.noarch 
yum install perl-Time-HiRes
yum -y install perl-Digest-MD5
rpm -ivh percona-toolkit-3.2.1-1.el7.x86_64.rpm
pt-table-checksum --help 看看是否装成功
pt-query-digest 慢日志文件路径

本作品采用《CC 协议》，转载必须注明作者和本文链接