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
  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.

Done! Now Read These: