mysqlreport使用_MySQL
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysqlreport使用_MySQL,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2852字,纯文字阅读大概需要5分钟。
内容图文
mysqlreport是www.hackmysql.com开发的一款基于perl语言编写的状态报告工具, 它将show status 和 show innodb status的输出结果进行处理,使得输出信息的可读性更高。由于是perl编写的脚本,所以需要先安装perl环境,再与mysql数据库连接,因此还需要安装数据库接口DBI 和数据库驱动 DBD-Mysql.安装DBI
yum install -y perl-DBI
安装mysqlreport
wget http://hackmysql.com/scripts/mysqlreport-3.5.tgztar zxvf mysqlreport-3.5.tgzcd mysqlreport-3.5perl 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.gzcd DBD-mysql-4.020perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_configmakemake install
把mysql的这个库文件路径添加进去
echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.confldconfig
再使用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看看,以下是部分输出结果的显示
本文出自 “老徐的私房菜” 博客,谢绝转载!
内容总结
以上是互联网集市为您收集整理的mysqlreport使用_MySQL全部内容,希望文章能够帮你解决mysqlreport使用_MySQL所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。