1. percona-toolkit Introduction
Percona-toolkit is a set of advanced command line tools used to execute various complicated and troublesome mysql and system tasks by hand, including:
Check master and slave Data Consistency
Effectively archive records
Searching duplicate Indexes
Summarize Server Information
Analyze queries from logs and tcpdump
Collect important system information when a system problem occurs
Percona-toolkit is derived from Maatkit and Aspersa. These two tools are the most famous tools for managing mysql. Now the Maatkit tool is no longer maintained. Please use percona-toolkit! These tools mainly include development, performance, configuration, monitoring, replication, system, and practicality. As an excellent DBA, some tools are very useful. If they can be mastered and applied flexibly, this will greatly improve work efficiency.
Ii. Install percona-toolkit
1. download the software package
Visit http://www.percona.com/software/percona-toolkit/download the latest percona Toolkit or use the following command line to obtain the latest version:
Wget percona.com/get/percona-toolkit.tar.gz
Wget percona.com/get/percona-toolkit.rpm
Click here to download the latest version from the website:
Wget http://www.percona.com/redir/downloads/percona-toolkit/2.1.1/percona-toolkit-2.1.1-1.noarch.rpm
Wget http://www.percona.com/redir/downloads/percona-toolkit/2.1.1/percona-toolkit-2.1.1.tar.gz
Download the latest termreadkeypackage from http://pkgs.repoforge.org/perl-termreadkey/
Wget http://pkgs.repoforge.org/perl-TermReadKey/perl-TermReadKey-2.30-1.el5.rf.x86_64.rpm
2. install the software package
My environment is CentOS 5.5 64 BIT
A. percona-toolkit rpm Installation Method
Rpm-ivh perl-TermReadKey-2.30-1.el5.rf.x86_64.rpm
Rpm-ivh percona-toolkit-2.1.1-1.noarch.rpm
Note: You need to install the Term: ReadKey package, otherwise perl (Term: ReadKey)> = 2.10 is needed by percona-toolkit-2.1.1-1.noarch error will be reported
B. Compile and install percona-toolkit
Tar xzvf percona-toolkit-2.1.1.tar.gz
Cd percona-toolkit-2.1.1
Perl Makefile. PL
Make
Make test
Make install
Percona Toolkit: click here
Percona Toolkit: click here