日期:2014-05-16  浏览次数:21012 次

Percona-Toolkit命令集合工具,Mysql不可或缺的必备利器之一

Percona Toolkit for MySQL is a collection of advanced command-line tools used by Percona MySQL support staff to perform a variety of MySQL server and system tasks that are too difficult or complex to perform manually, including:

1.对主从复制数据的一致性校验;

2.有效的对相关的行数据进行归档操作;

3.查到相关的重复的索引;

4.归总大批量Mysql服务的维护运维工作;

5.问题发生时收集重要的系统信息;

官网项目地址;

http://www.percona.com/software/percona-toolkit/ 

相关配置如下:

[root@Slave02 local]# wget percona.com/get/percona-toolkit.tar.gz
--2013-04-01 13:20:06--  http://percona.com/get/percona-toolkit.tar.gz
Resolving percona.com... 74.121.199.234
Connecting to percona.com|74.121.199.234|:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://www.percona.com/get/percona-toolkit.tar.gz [following]
--2013-04-01 13:20:07--  http://www.percona.com/get/percona-toolkit.tar.gz
Resolving www.percona.com... 74.121.199.234
Reusing existing connection to percona.com:80.
HTTP request sent, awaiting response... 302 Found
Location: http://www.percona.com/downloads/percona-toolkit/2.2.1/percona-toolkit-2.2.1.tar.gz [following]
--2013-04-01 13:20:08--  http://www.percona.com/downloads/percona-toolkit/2.2.1/percona-toolkit-2.2.1.tar.gz
Reusing existing connection to percona.com:80.
HTTP request sent, awaiting response... 200 OK
Length: 1343968 (1.3M) [application/x-gzip]
Saving to: `percona-toolkit-2.2.1.tar.gz'

100%[======================================>] 1,343,968   26.9K/s   in 76s     

2013-04-01 13:21:24 (17.3 KB/s) - `percona-toolkit-2.2.1.tar.gz' saved [1343968/1343968]

[root@Slave02 local]# ls
bin                   mysql
cmake-2.8.5           mysqlsla-2.03
doc                   mysqlsla-2.03.tar.gz
etc                   percona-toolkit-2.2.1.tar.gz
games                 puppetlabs-release-6-1.noarch.rpm
include               sbin
innotop-1.8.1         share
innotop-1.8.1.tar.gz  software
lib                   src
libexec               xtrabackup-1.6.2
man                   xtrabackup-1.6.2.tar.gz
[root@Slave02 local]#

然后进行相关的perl配置包文件,如下:

进入cpan对其进行安装
#perl -MCPAN -e shell
cpan>install DBI
cpan>install DBD::mysql
cpan>install CGI

cpan[3]> install CGI                                                            
Running install for module 'CGI'
Running make for M/MA/MARKSTOS/CGI.pm-3.63.tar.gz
Fetching with LWP:
http://mirrors.sohu.com/CPAN/authors/id/M/MA/MARKSTOS/CGI.pm-3.63.tar.gz
Fetching with LWP:
http://mirrors.sohu.com/CPAN/authors/id/M/MA/MARKSTOS/CHECKSUMS
Checksum for /root/.cpan/sources/authors/id/M/MA/MARKSTOS/CGI.pm-3.63.tar.gz ok

  CPAN.pm: Building M/MA/MARKSTOS/CGI.pm-3.63.tar.gz

Checking if your kit is complete...
Looks good
Warning: prerequisite FCGI 0.67 not found.
Writing Makefile for CGI
Writing MYMETA.yml an