Percona_Toolkit 简介及安装 -- MySQL管理员必备的工具包

2014-11-24 17:54:28 · 作者: · 浏览: 1

Percona_Toolkit


Percona Toolkit 的简介:(来自官方的简介)


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


-Verify master and replica data consistency


-Efficiently archive rows


-Find duplicate indexes


-Summarize MySQL servers


-Analyze queries from logs and tcpdump


-Collect vital system information when problems occur


Percona Toolkit 的系统要求:(或者称为环境变量的要求)


Most tools require:


* Perl v5.8 or newer


* Bash v3 or newer


* Core Perl modules like Times:HiRes


Tools that connect to MySQL require:


* Perl modules DBI and DBD::mysql and perl-IO-Socket-SSL


* MySQL 5.0 or newer


注释:rpm安装Percona Toolkit 具体需安装perl的那些模块根据自己的系统环境或者参考安装过程碰到的错误去决定需安装那些。


Percona Toolkit 的安装:


1:下载percona toolkit的包:(可以是源码包,或者RPM)


访问:http://www.percona.com/software/percona-toolkit/ 下载最新稳定的版本。也可以如下命令行的方式下载最新版本。


wget percona.com/get/percona-toolkit.tar.gz


wget percona.com/get/percona-toolkit.rpm


2:安装于Perl相关的模块


yum install perl-DBI


yum install perl-DBD-MySQL


yum install perl-Time-HiRes


yum install perl-IO-Socket-SSL


3: 安装Percona Toolkit


rpm -Uvh percona-toolkit-2.2.1-2.noarch.rpm


OK,就这么简单,安装完毕。


特别说明:


本机为:Linux mysql.example.com 2.6.18-308.el5 #1 SMP Tue Feb 21 20:06:06 EST 2012 x86_64 x86_64 x86_64 GNU/Linux


安装错误:


在yum install perl-DBD-MySQL时,出现如下错误信息


---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated


--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: perl-DBD-MySQL


--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: perl-DBD-MySQL


--> Running transaction check


---> Package mysql.x86_64 0:5.0.95-5.el5_9 set to be updated


--> Processing Conflict: mysql conflicts MySQL


--> Finished Dependency Resolution


mysql-5.0.95-5.el5_9.x86_64 from updates has depsolving problems


--> mysql conflicts with MySQL-server


Error: mysql conflicts with MySQL-server


rpm -Uvh MySQL-shared-compat-5.5.31-1.rhel5.x86_64.rpm


MySQL-shared-compat为客户端的libraries ,向下兼容。


在yum install perl-DBD-MySQL就没有问题了。