本文共 15252 字，大约阅读时间需要 50 分钟。

1、percona-toolkit简介

percona-toolkit是一组高级命令行工具的集合，用来执行各种通过手工执行非常复杂和麻烦的mysql和系统任务，这些任务包括： l  检查master和slave数据的一致性 l  有效地对记录进行归档 l  查找重复的索引 l  对服务器信息进行汇总 l  分析来自日志和tcpdump的查询 l  当系统出问题的时候收集重要的系统信息 percona-toolkit源自Maatkit 和Aspersa工具，这两个工具是管理mysql的最有名的工具，现在Maatkit工具已经不维护了，请大家还是使用percona-toolkit吧！这些工具主要包括开发、性能、配置、监控、复制、系统、实用六大类，作为一个优秀的DBA，里面有的工具非常有用，如果能掌握并加以灵活应用，将能极大的提高工作效率。2、下载 Download address:   http://www.percona.com/redir/downloads/percona-toolkit/LATEST/percona-toolkit-2.2.5.tar.gz [root@472322 ~]# cd down/ [root@472322 down]# wget http://www.percona.com/redir/downloads/percona-toolkit/LATEST/percona-toolkit-2.2.5.tar.gz --2013-10-30 23:27:56--  http://www.percona.com/redir/downloads/percona-toolkit/LATEST/percona-toolkit-2.2.5.tar.gz Resolving www.percona.com... 74.121.199.234 Connecting to www.percona.com|74.121.199.234|:80... connected. HTTP request sent, awaiting response... 302 Found Location: /downloads/percona-toolkit/LATEST/percona-toolkit-2.2.5.tar.gz [following] --2013-10-30 23:27:56--  http://www.percona.com/downloads/percona-toolkit/LATEST/percona-toolkit-2.2.5.tar.gz Reusing existing connection to www.percona.com:80. HTTP request sent, awaiting response... 200 OK Length: 1447292 (1.4M) [application/x-gzip] Saving to: 鈥減ercona-toolkit-2.2.5.tar.gz鈥 100%[=============================================================================================================================>] 1,447,292    874K/s   in 1.6s     2013-10-30 23:27:57 (874 KB/s) - 鈥減ercona-toolkit-2.2.5.tar.gz鈥saved [1447292/1447292] 下载完毕。3、安装 [root@472322 percona-toolkit-2.2.5]# tar -xvf percona-toolkit-2.2.5.tar.gz [root@472322 percona-toolkit-2.2.5]# cd percona-toolkit-2.2.53.1 perl Makefile.PL [root@472322 percona-toolkit-2.2.5]# perl Makefile.PL Can't locate ExtUtils/MakeMaker.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at Makefile.PL line 1. BEGIN failed--compilation aborted at Makefile.PL line 1. 可能是perl，make没有安装吧，yum安装下perl以及make试试： [root@472322 percona-toolkit-2.2.5]# yum install perl Loaded plugins: dellsysid, fastestmirror, presto Determining fastest mirrors epel/metalink                                                                                                                                   |  16 kB     00:00       * base: mirror.rackspace.com  * dell-community: linux.dell.com  * epel: fedora-epel.mirror.lstn.net  * extras: mirrordenver.fdcservers.net  * updates: centos.mirror.lstn.net ............................... 此处省略.............................. Updated:   perl.x86_64 4:5.10.1-131.el6_4                                                                                                                                        Dependency Updated:   perl-Compress-Raw-Zlib.x86_64 1:2.020-131.el6_4         perl-Compress-Zlib.x86_64 0:2.020-131.el6_4           perl-IO-Compress-Base.x86_64 0:2.020-131.el6_4           perl-IO-Compress-Zlib.x86_64 0:2.020-131.el6_4          perl-Module-Pluggable.x86_64 1:3.90-131.el6_4         perl-Pod-Escapes.x86_64 1:1.04-131.el6_4                 perl-Pod-Simple.x86_64 1:3.13-131.el6_4                 perl-libs.x86_64 4:5.10.1-131.el6_4                   perl-version.x86_64 3:0.77-131.el6_4                   Complete! [root@472322 percona-toolkit-2.2.5]# make make: *** No targets specified and no makefile found.  Stop. [root@472322 percona-toolkit-2.2.5]# yum install -y make Loaded plugins: dellsysid, fastestmirror, presto Loading mirror speeds from cached hostfile  * base: mirror.rackspace.com  * dell-community: linux.dell.com  * epel: fedora-epel.mirror.lstn.net  * extras: mirrordenver.fdcservers.net  * updates: centos.mirror.lstn.net Setting up Install Process Package 1:make-3.81-20.el6.x86_64 already installed and latest version Nothing to do [root@472322 percona-toolkit-2.2.5]#  [root@472322 percona-toolkit-2.2.5]# perl Makefile.PL Can't locate ExtUtils/MakeMaker.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at Makefile.PL line 1. BEGIN failed--compilation aborted at Makefile.PL line 1. google，找到需要安装一些perl组件：  [root@472322 percona-toolkit-2.2.5]# yum install perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker Loaded plugins: dellsysid, fastestmirror, presto Loading mirror speeds from cached hostfile  * base: mirror.rackspace.com  * dell-community: linux.dell.com  * epel: fedora-epel.mirror.lstn.net  * extras: mirrordenver.fdcservers.net  * updates: centos.mirror.lstn.net Setting up Install Process ............................... 此处省略.............................. Dependency Installed:   perl-ExtUtils-ParseXS.x86_64 1:2.2003.0-131.el6_4             perl-Test-Harness.x86_64 0:3.17-131.el6_4             perl-devel.x86_64 4:5.10.1-131.el6_4             Complete!OK，再试下： [root@472322 percona-toolkit-2.2.5]# perl Makefile.PL Checking if your kit is complete... Warning: the following files are missing in your kit:         bin/pt-agent.~1~         bin/pt-agent.~2~         bin/pt-align.~1~         bin/pt-align.~2~         bin/pt-archiver.~1~         bin/pt-archiver.~2~         bin/pt-config-diff.~1~         bin/pt-config-diff.~2~         bin/pt-deadlock-logger.~1~         bin/pt-deadlock-logger.~2~         bin/pt-diskstats.~1~         bin/pt-diskstats.~2~         bin/pt-duplicate-key-checker.~1~         bin/pt-duplicate-key-checker.~2~         bin/pt-fifo-split.~1~         bin/pt-fifo-split.~2~         bin/pt-find.~1~         bin/pt-find.~2~         bin/pt-fingerprint.~1~         bin/pt-fingerprint.~2~         bin/pt-fk-error-logger.~1~         bin/pt-fk-error-logger.~2~         bin/pt-heartbeat.~1~         bin/pt-heartbeat.~2~         bin/pt-index-usage.~1~         bin/pt-index-usage.~2~         bin/pt-ioprofile.~1~         bin/pt-ioprofile.~2~         bin/pt-kill.~1~         bin/pt-kill.~2~         bin/pt-mext.~1~         bin/pt-mext.~2~         bin/pt-mysql-summary.~1~         bin/pt-mysql-summary.~2~         bin/pt-online-schema-change.~1~         bin/pt-online-schema-change.~2~         bin/pt-pmp.~1~         bin/pt-pmp.~2~         bin/pt-query-digest.~1~         bin/pt-query-digest.~2~         bin/pt-show-grants.~1~         bin/pt-show-grants.~2~         bin/pt-sift.~1~         bin/pt-sift.~2~         bin/pt-slave-delay.~1~         bin/pt-slave-delay.~2~         bin/pt-slave-find.~1~         bin/pt-slave-find.~2~         bin/pt-slave-restart.~1~         bin/pt-slave-restart.~2~         bin/pt-stalk.~1~         bin/pt-stalk.~2~         bin/pt-summary.~1~         bin/pt-summary.~2~         bin/pt-table-checksum.~1~         bin/pt-table-checksum.~2~         bin/pt-table-sync.~1~         bin/pt-table-sync.~2~         bin/pt-table-usage.~1~         bin/pt-table-usage.~2~         bin/pt-upgrade.~1~         bin/pt-upgrade.~2~         bin/pt-variable-advisor.~1~         bin/pt-variable-advisor.~2~         bin/pt-visual-explain.~1~         bin/pt-visual-explain.~2~         Changelog.~1~         Changelog.~2~         Makefile.PL.~1~         Makefile.PL.~2~         MANIFEST.~1~ Please inform the author. Warning: prerequisite DBD::mysql 3 not found. Warning: prerequisite DBI 1.46 not found. Writing Makefile for percona-toolkit3.2 make [root@472322 percona-toolkit-2.2.5]# make cp bin/pt-mysql-summary blib/script/pt-mysql-summary /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-mysql-summary cp bin/pt-kill blib/script/pt-kill /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-kill cp bin/pt-online-schema-change blib/script/pt-online-schema-change /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-online-schema-change cp bin/pt-table-sync blib/script/pt-table-sync /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-table-sync cp bin/pt-upgrade blib/script/pt-upgrade /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-upgrade cp bin/pt-table-usage blib/script/pt-table-usage /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-table-usage cp bin/pt-fifo-split blib/script/pt-fifo-split /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-fifo-split cp bin/pt-slave-find blib/script/pt-slave-find /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-slave-find cp bin/pt-agent blib/script/pt-agent /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-agent cp bin/pt-ioprofile blib/script/pt-ioprofile /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-ioprofile cp bin/pt-find blib/script/pt-find /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-find cp bin/pt-archiver blib/script/pt-archiver /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-archiver cp bin/pt-deadlock-logger blib/script/pt-deadlock-logger /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-deadlock-logger cp bin/pt-fingerprint blib/script/pt-fingerprint /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-fingerprint cp bin/pt-mext blib/script/pt-mext /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-mext cp bin/pt-slave-restart blib/script/pt-slave-restart /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-slave-restart cp bin/pt-summary blib/script/pt-summary /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-summary cp bin/pt-fk-error-logger blib/script/pt-fk-error-logger /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-fk-error-logger cp bin/pt-table-checksum blib/script/pt-table-checksum /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-table-checksum cp bin/pt-query-digest blib/script/pt-query-digest /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-query-digest cp bin/pt-show-grants blib/script/pt-show-grants /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-show-grants cp bin/pt-pmp blib/script/pt-pmp /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-pmp cp bin/pt-align blib/script/pt-align /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-align cp bin/pt-heartbeat blib/script/pt-heartbeat /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-heartbeat cp bin/pt-slave-delay blib/script/pt-slave-delay /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-slave-delay cp bin/pt-sift blib/script/pt-sift /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-sift cp bin/pt-diskstats blib/script/pt-diskstats /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-diskstats cp bin/pt-visual-explain blib/script/pt-visual-explain /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-visual-explain cp bin/pt-variable-advisor blib/script/pt-variable-advisor /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-variable-advisor cp bin/pt-index-usage blib/script/pt-index-usage /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-index-usage cp bin/pt-duplicate-key-checker blib/script/pt-duplicate-key-checker /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-duplicate-key-checker cp bin/pt-config-diff blib/script/pt-config-diff /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-config-diff cp bin/pt-stalk blib/script/pt-stalk /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-stalk Manifying blib/man1/pt-mysql-summary.1p Manifying blib/man1/pt-kill.1p Manifying blib/man1/pt-online-schema-change.1p Manifying blib/man1/pt-table-sync.1p Manifying blib/man1/pt-upgrade.1p Manifying blib/man1/pt-table-usage.1p Manifying blib/man1/pt-fifo-split.1p Manifying blib/man1/pt-slave-find.1p Manifying blib/man1/pt-agent.1p Manifying blib/man1/pt-ioprofile.1p Manifying blib/man1/pt-find.1p Manifying blib/man1/pt-archiver.1p Manifying blib/man1/pt-deadlock-logger.1p Manifying blib/man1/pt-fingerprint.1p Manifying blib/man1/pt-mext.1p Manifying blib/man1/pt-slave-restart.1p Manifying blib/man1/pt-summary.1p Manifying blib/man1/pt-fk-error-logger.1p Manifying blib/man1/pt-table-checksum.1p Manifying blib/man1/pt-query-digest.1p Manifying blib/man1/pt-show-grants.1p Manifying blib/man1/percona-toolkit.1p Manifying blib/man1/pt-pmp.1p Manifying blib/man1/pt-align.1p Manifying blib/man1/pt-heartbeat.1p Manifying blib/man1/pt-slave-delay.1p Manifying blib/man1/pt-sift.1p Manifying blib/man1/pt-diskstats.1p Manifying blib/man1/pt-visual-explain.1p Manifying blib/man1/pt-variable-advisor.1p Manifying blib/man1/pt-index-usage.1p Manifying blib/man1/pt-duplicate-key-checker.1p Manifying blib/man1/pt-config-diff.1p Manifying blib/man1/pt-stalk.1p3.3  make install [root@472322 percona-toolkit-2.2.5]# make install Installing /usr/local/share/man/man1/pt-ioprofile.1p Installing /usr/local/share/man/man1/pt-sift.1p Installing /usr/local/share/man/man1/pt-query-digest.1p Installing /usr/local/share/man/man1/pt-table-sync.1p Installing /usr/local/share/man/man1/pt-summary.1p Installing /usr/local/share/man/man1/pt-duplicate-key-checker.1p Installing /usr/local/share/man/man1/pt-online-schema-change.1p Installing /usr/local/share/man/man1/pt-pmp.1p Installing /usr/local/share/man/man1/pt-mext.1p Installing /usr/local/share/man/man1/pt-kill.1p Installing /usr/local/share/man/man1/pt-config-diff.1p Installing /usr/local/share/man/man1/pt-slave-restart.1p Installing /usr/local/share/man/man1/pt-deadlock-logger.1p Installing /usr/local/share/man/man1/pt-variable-advisor.1p Installing /usr/local/share/man/man1/pt-index-usage.1p Installing /usr/local/share/man/man1/pt-fk-error-logger.1p Installing /usr/local/share/man/man1/pt-find.1p Installing /usr/local/share/man/man1/pt-upgrade.1p Installing /usr/local/share/man/man1/pt-fingerprint.1p Installing /usr/local/share/man/man1/pt-show-grants.1p Installing /usr/local/share/man/man1/pt-archiver.1p Installing /usr/local/share/man/man1/pt-visual-explain.1p Installing /usr/local/share/man/man1/pt-stalk.1p Installing /usr/local/share/man/man1/pt-slave-delay.1p Installing /usr/local/share/man/man1/pt-diskstats.1p Installing /usr/local/share/man/man1/pt-heartbeat.1p Installing /usr/local/share/man/man1/pt-table-checksum.1p Installing /usr/local/share/man/man1/pt-agent.1p Installing /usr/local/share/man/man1/percona-toolkit.1p Installing /usr/local/share/man/man1/pt-fifo-split.1p Installing /usr/local/share/man/man1/pt-align.1p Installing /usr/local/share/man/man1/pt-table-usage.1p Installing /usr/local/share/man/man1/pt-slave-find.1p Installing /usr/local/share/man/man1/pt-mysql-summary.1p Installing /usr/local/bin/pt-table-usage Installing /usr/local/bin/pt-find Installing /usr/local/bin/pt-kill Installing /usr/local/bin/pt-ioprofile Installing /usr/local/bin/pt-stalk Installing /usr/local/bin/pt-agent Installing /usr/local/bin/pt-deadlock-logger Installing /usr/local/bin/pt-sift Installing /usr/local/bin/pt-pmp Installing /usr/local/bin/pt-fingerprint Installing /usr/local/bin/pt-heartbeat Installing /usr/local/bin/pt-summary Installing /usr/local/bin/pt-diskstats Installing /usr/local/bin/pt-slave-restart Installing /usr/local/bin/pt-index-usage Installing /usr/local/bin/pt-variable-advisor Installing /usr/local/bin/pt-archiver Installing /usr/local/bin/pt-duplicate-key-checker Installing /usr/local/bin/pt-slave-find Installing /usr/local/bin/pt-visual-explain Installing /usr/local/bin/pt-align Installing /usr/local/bin/pt-table-checksum Installing /usr/local/bin/pt-mysql-summary Installing /usr/local/bin/pt-fifo-split Installing /usr/local/bin/pt-show-grants Installing /usr/local/bin/pt-query-digest Installing /usr/local/bin/pt-upgrade Installing /usr/local/bin/pt-slave-delay Installing /usr/local/bin/pt-online-schema-change Installing /usr/local/bin/pt-fk-error-logger Installing /usr/local/bin/pt-mext Installing /usr/local/bin/pt-table-sync Installing /usr/local/bin/pt-config-diff Appending installation info to /usr/lib64/perl5/perllocal.pod 此致，percona-toolkit安装完毕。4、后话 percona-toolkit的rpm安装方式，google得到的，杉树自己没有安装过。 rpm -ivh perl-TermReadKey-2.30-1.el5.rf.x86_64.rpm rpm -ivh percona-toolkit-2.1.1-1.noarch.rpm

转载地址：http://pfcsz.baihongyu.com/