使用mysqlreport查看Mysql数据库信息
mysqlreport是www.hackmysql.com开发的一款基于perl语言编写的状态报告工具。
它将show status 和 show innodb status的输出结果进行处理,使得输出信息的可读性更高。由于是perl编写的脚本,所以需要先安装perl环境,再与mysql数据库连接,因此还需要安装数据库接口DBI 和数据库驱动 DBD-Mysql.
安装perl-DBI
yum install -y perl-DBI
安装mysqlreport
wget http://hackmysql.com/scripts/mysqlreport-3.5.tgz tar zxvf mysqlreport-3.5.tgz cd mysqlreport-3.5 perl mysqlreport -u root -password 12345
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 8) 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
出现以上错误,原因是没有安装DBD-mysql,下载安装
wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-4.020.tar.gz cd DBD-mysql-4.020 perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config make make install
把mysql的这个库文件路径添加进去
echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf ldconfig
再使用mysqlreport
perl mysqlreport -u root -password 12345
脚本有些小的bug,会出现以下错误信息
Use of uninitialized value in multiplication (*) at mysqlreport line 829. Use of uninitialized value in formline at mysqlreport line 1227. Use of uninitialized value in formline at mysqlreport line 1235.
829行修改成如下方式,则不再提示错误
my $is = @_; my $of = @_; return sprintf "%.2f", ($is * 100) / ($of ||= 1);
再分析1227和1235行错误
1227 $stats{‘Innodb_buffer_pool_pages_latched‘}, perc($stats{‘Innodb_buffer_pool_pages_latched‘}, $stats{‘Innodb_buffer_pool_pages_total‘})
1235 $stats{‘Innodb_buffer_pool_read_ahead_seq‘}, t($stats{‘Innodb_buffer_pool_read_ahead_seq‘})
查看mysql官方手册
Innodb_buffer_pool_pages_latched
The number of latched pages in InnoDB buffer pool. These are pages currently being read or written or that cannot be flushed or removed for some other reason. Calculation of this variable is expensive, so as of MySQL 5.1.28, it is available only when the UNIV_DEBUG system is defined at server build time.
5.1.28后不默认提供这个参数了。除非编译的时候强制指定。
Innodb_buffer_pool_read_ahead_seq
The number of sequential read-aheads initiated by InnoDB
. This happens when InnoDB
does a sequential full table scan.
For InnoDB Plugin
, this variable was removed in MySQL 5.1.41.
这个变量是InnoDB的存储引擎插件,在5.1.41以后就已经被移除,这里我的数据库是5.5.25,所以以上两个错误不是很重要。
最后执行mysqlreport -u -password 12345看看,以下是部分输出结果的显示
本文出自 “老徐的私房菜” 博客,谢绝转载!
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。