Version 3.0 of mysqlreport releasedFri, Dec 8, 2006 in Databases
Daniel Nichter has released version 3.0 of mysqlreport, one of my favorite tools for quickly comprehending the overall state of a MySQL server. The new version prints out the most important information about InnoDB.
It looks like this:
$ perl mysqlreport --innodb-only MySQL 5.0.26-standard-l uptime 3 9:57:51 Fri Dec 8 17:29:07 2006 __ InnoDB Buffer Pool __________________________________________________ Usage 1.25G of 1.25G %Used: 100.00 Read ratio 0.002 Pages Free 1 %Total: 0.00 Data 78.94k 96.37 %Drty: 0.01 Misc 2976 3.63 Latched 0 0.00 Reads 3.47G 11.7k/s From file 6.30M 21.4/s 0.18 Ahead Rnd 216772 0.7/s Ahead Sql 181211 0.6/s Writes 811.05M 2.7k/s Flushes 4.16M 14.1/s Wait Free 0 0/s __ InnoDB Lock _________________________________________________________ Waits 680 0.0/s Current 0 Time acquiring Total 492478 ms Average 724 ms Max 5182 ms
As always, very helpful… just the facts, nothing more. I have 1.25 GB of buffer pool, 100% used, very small percentage of dirty pages, etc etc. You can see it all at a glance.
It pulls the data from
SHOW STATUS, which means it only works on newer versions of MySQL. Those variables are available in 5.0.3 and later, if memory serves me.
About The Author
Baron is the founder and CEO of VividCortex. He is the author of High Performance MySQL and many open-source tools for performance analysis, monitoring, and system administration. Baron contributes to various database communities such as Oracle, PostgreSQL, Redis and MongoDB.