mysqlreport安装和基本使用
上一篇 /
下一篇 2014-09-22 17:04:38
/ 个人分类:测试资料
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/
DBD下载web:
收藏
举报
TAG: