[root@server152 mysqlreport-3.5]# ./mysqlreport -help
mysqlreport v3.5 Apr 16 2008
mysqlreport makes an easy-to-read report of important MySQL status values.
Command line options (abbreviations work):
--user USER Connect to MySQL as USER
--password PASS Use PASS or prompt for MySQL user's password
--host ADDRESS Connect to MySQL at ADDRESS
--port PORT Connect to MySQL at PORT
--socket SOCKET Connect to MySQL at SOCKET
--no-mycnf Don't read ~/.my.cnf
--infile FILE Read status values from FILE instead of MySQL
--outfile FILE Write report to FILE
--email ADDRESS Email report to ADDRESS (doesn't work on Windows)
--flush-status Issue FLUSH STATUS; after getting current values
--relative X Generate relative reports. If X is an integer,
reports are live from the MySQL server X seconds apart.
If X is a list of infiles (file1 file2 etc.),
reports are generated from the infiles in the order
that they are given.
--report-count N Collect N number of live relative reports (default 1)
--detach Fork and detach from terminal (run in background)
--help Prints this
--debug Print debugging information
Visit http://hackmysql.com/mysqlreport for more information.
[root@server152 mysqlreport-3.5]# ./mysqlreport --user root --password mypassword --socket /tmp/mysql.sock
MySQL 4.0.24-8264.com-l uptime 0 0:8:28 Mon Jul 14 00:41:00 2008
__ Key _________________________________________________________________
Buffer used 12.40M of 384.00M %Used: 3.23
Write hit 12.52%
Read hit 98.16%
__ Questions ___________________________________________________________
Total 44.32k 87.2/s
DMS 24.96k 49.1/s %Total: 56.33
COM_QUIT 6.99k 13.8/s 15.76
Com_ 6.84k 13.5/s 15.43
QC Hits 3.56k 7.0/s 8.04
+Unknown 1.97k 3.9/s 4.44
Slow 10 s 0 0/s 0.00 %DMS: 0.00 Log: OFF
DMS 24.96k 49.1/s 56.33
SELECT 17.20k 33.9/s 38.81 68.90
UPDATE 3.25k 6.4/s 7.33 13.01
INSERT 2.43k 4.8/s 5.49 9.74
DELETE 1.84k 3.6/s 4.14 7.36
REPLACE 247 0.5/s 0.56 0.99
Com_ 6.84k 13.5/s 15.43
change_db 6.81k 13.4/s 15.37
show_variab 15 0.0/s 0.03
show_status 6 0.0/s 0.01
__ SELECT and Sort _____________________________________________________
Scan 877 1.7/s %SELECT: 5.10
Range 830 1.6/s 4.83
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 431 0.8/s
Sort range 1.50k 3.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 5.62M of 32.00M %Used: 17.56
Block Fragmnt 10.16%
Hits 3.56k 7.0/s
Inserts 17.06k 33.6/s
Insrt:Prune 17.06k:1 33.6/s
Hit:Insert 0.21:1
__ Table Locks _________________________________________________________
Waited 674 1.3/s %Total: 2.00
Immediate 33.05k 65.1/s
__ Tables ______________________________________________________________
Open 181 of 256 %Cache: 70.70
Opened 192 0.4/s
__ Connections _________________________________________________________
Max used 14 of 400 %Max: 3.50
Total 7.00k 13.8/s
__ Created Temp ________________________________________________________
Disk table 31 0.1/s
Table 148 0.3/s Size: 32.0M
File 0 0/s
__ Threads _____________________________________________________________
Running 3 of 6
Cached 4 of 8 %Hit: 99.53
Created 33 0.1/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 24 0.0/s
Connects 8 0.0/s
__ Bytes _______________________________________________________________
Sent 39.74M 78.2k/s
Received 6.37M 12.5k/s