Install and Use Pt-ioprofile

Pt-ioprofile is a percona performance analysis tool that allows you to view process output, input, and print some table files and active Io files. Pt-ioprofile is a read-only tool, so there is no risk for data. Many of your friends have no instructions on installing Pt-ioprofile on the Internet. ^. ^

The following describes how to install Pt-ioprofile:

#!/bin/bashtoolkit(){version=$(cat /etc/redhat-release | awk ‘{print $3}‘ | awk -F ‘.‘ ‘{print $1}‘)if [ $version -eq 6 ]then   rpm -ivh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpmelse   rpm -ivh http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpmfiyum install perl-IO-Socket-SSL perl-DBD-MySQL perl-Time-HiRes -ywget http://www.percona.com/downloads/percona-toolkit/LATEST/RPM/percona-toolkit-2.2.11-1.noarch.rpmrpm -ivh percona-toolkit-2.2.11-1.noarch.rpm}toolkit

If the following error is reported during installation

Error: Cannot retrieve metalink for repository: epel. Please verify its path and try againerror: Failed dependencies:        perl(DBI) >= 1.13 is needed by percona-toolkit-2.2.11-1.noarch        perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.11-1.noarch        perl(Time::HiRes) is needed by percona-toolkit-2.2.11-1.noarch        perl(IO::Socket::SSL) is needed by percona-toolkit-2.2.11-1.noarch

The reason is that after rpm-uvh has an epel extension, yum cannot be installed. The solution is to edit/etc/yum. repos. d/epel. repo: comment out the basic recovery and image address,

# Change baseurlmirrorlist to baseurl # upload list

Run the script to install it.
See http://www.cnblogs.com/cenalulu/archive/2013/04/12/3016714.html

See http://www.percona.com/doc/percona-toolkit/2.0/pt-ioprofile.html

Install and Use Pt-ioprofile