mysqlreport安装和基本使用

mysqlreport是由
hackmysql.com 的站长所撰写的 Perl Scritps，旨在协助 MySQL DBA 搜集与分析 MySQL 的运作状况。
官方网站：
http://hackmysql.com/
软件下载：
http://hackmysql.com/mysqlreport

linux系统下

MySQLReport 是用perl语言编写，所以想要运行它首先需要安装perl环境；它还要与MySQL数据库连接，所以还需要安装数据库接口 DBI 和数据库驱动 DBD-MySQL

wget  -S http://hackmysql.com/scripts/mysqlreport-3.5.tgz

tar zxvf mysqlreport-3.5.tgz

cd mysqlreport-3.5

cp mysqlreport /usr/local/nmp/mysql/bin/

cd /usr/local/nmp/mysql/bin/

./mysqlreport --socket /tmp/mysql.sock

出现问题了 如下

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 .) at (eval 7) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge.
 at ./mysqlreport line 249

------------------------------

#yum list|grep DBD

perl-DBD-MySQL.i386                      3.0007-2.el5                  base    
perl-DBD-Pg.i386                         1.49-2.el5_3.1                base

#yum list|grep DBI
perl-DBI.i386                            1.52-2.el5                    installed

安装下perl-DBD-MySQL

yum -y install perl-DBD-MySQL.i386

再试下

./mysqlreport --socket /tmp/mysql.sock

可以了

 一篇介绍 mysqlreport 工具使用相关的中文教程 http://www.phpv.net/html/1566.html

DBI下载web:

http://www.cpan.org/modules/by-module/DBI/