Mysql Database Status report using mysqlreport

What is mysqlreport ?

mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides a much more in-depth understanding of how well MySQL is running. For this and many other reasons, mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS.

Download mysqlreport

http://hackmysql.com/mysqlreport

Mysqlreport Documentation

http://hackmysql.com/mysqlreportdoc

Installing mysqlreport in Debian

You need to download the latest version of mysqlreport from http://hackmysql.com/mysqlreport

Once you downloaded .tgz file you need to extarct this file using the following command

#tar xzvf mysqlreport.tgz

Now you can see three file as below

mysqlreport  mysqlreportdoc.txt  mysqlreportguide.txt

If you want to run mysqlreport on your server you need to have mysql database server need to be installed.If you want to install mysql on your server check here

Now if you want to run the mysqlreport just run the following command

#./mysqlreport

Output looks like below

MySQL 4.1.11-Debian_4sa  uptime 7 3:7:50        Mon Jul 24 13:47:36 2006

__ Key _________________________________________________________________
Buffer usage  122.00k of  16.00M  %Used:   0.74
Write ratio      0.94
Read ratio       0.00

__ Questions ___________________________________________________________
Total         149.63k    0.24/s
Slow                0    0.00/s  %Total:   0.00  %DMS:   0.00
DMS            93.86k    0.15/s           62.73

__ Table Locks _________________________________________________________
Waited             39    0.00/s  %Total:   0.04
Immediate      95.75k    0.16/s

__ Tables ______________________________________________________________
Open               55 of   64    %Cache:  85.94
Opened            175    0.00/s

__ Connections _________________________________________________________
Max used            4 of  100      %Max:   4.00
Total           7.85k    0.01/s

__ Created Temp ________________________________________________________
Disk table          1    0.00/s
Table              32    0.00/s
File                3    0.00/s

Now the important part will start you need to understand this report to know exactly what it is telling you for this you need to follow this guide