Percona-toolkit is a collection of advanced command-line tools that perform a variety of manual execution of very complex and cumbersome MySQL and system tasks, including:
??? 1. Check the consistency of master and slave data
??? 2. Efficient archiving of records
??? 3. Finding duplicate Indexes
??? 4. Summarize the server information
??? 5. Analyze queries from logs and tcpdump
??? 6. Collect important System information when the system goes wrong
Percona-toolkit originates from the Maatkit and ASPERSA tools, which are the most famous tools for managing MySQL, and now maatkit tools are not maintained anymore, so use Percona-toolkit! These tools mainly include development, performance, configuration, monitoring, replication, System, practical six categories, some of the tools are very useful, if you can master and flexible application, will be able to greatly improve work efficiency.
Package Download:
Visit http://www.percona.com/software/percona-toolkit/to download the latest version of Percona Toolkit
Installation steps:
wget https://www.percona.com/downloads/percona-toolkit/2.2.14/RPM/percona-toolkit-2.2.14-1.noarch.rpm
Note: It is possible that there will be other installation package dependencies on your machine, but you can follow the following method to find out the corresponding dependency package and install it, the process is very simple.
[Email protected] src]# RPM-IVH percona-toolkit-2.2.14-1.noarch.rpm
Warning:percona-toolkit-2.2.14-1.noarch.rpm:header V4 dsa/sha1 Signature, key ID Cd2efd2a:nokey
error:failed dependencies:
Perl (Time::hires) is needed by Percona-toolkit-2.2.14-1.noarch
Perl (IO::SOCKET::SSL) is needed by Percona-toolkit-2.2.14-1.noarch
Perl (Term::readkey) is needed by Percona-toolkit-2.2.14-1.noarch
[Email protected] src]# yum list|grep time|grep hires
perl-time-hires.x86_64 4:1.9721-141.el6 @base
Therefore:yum install perl-time-hires.x86_64
[Email protected] src]# Yum list | grep Socket | grep SSL
Perl-io-socket-ssl.noarch 1.31-2.EL6 Base
Therefore:yum install Perl-io-socket-ssl.noarch
[Email protected] src]# Yum list | grep ReadKey
perl-termreadkey.x86_64 2.30-13.EL6 Base
Therefore:yum install perl-termreadkey.x86_64
Last: Rpm-ivh percona-toolkit-2.2.14-1.noarch.rpm
[Email protected] src]# RPM-IVH percona-toolkit-2.2.14-1.noarch.rpm
Warning:percona-toolkit-2.2.14-1.noarch.rpm:header V4 dsa/sha1 Signature, key ID Cd2efd2a:nokey
Preparing ... ########################################### [100%]
1:percona-toolkit ########################################### [100%]
Installation is complete!
Percona-toolkit Introduction and Installation