Introduction and installation of Percona Toolkit series

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