Percona-toolkit Introduction and Installation

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