mysqlreport Live Demonstration
MySQL 4.1.25-Debian_mt1 uptime 434 12:53:23 Thu Sep 2 13:38:59 2010
__ Key _________________________________________________________________
Buffer used 788.00k of 32.00M %Used: 2.40
Current 4.37M %Usage: 13.64
Write hit 27.23%
Read hit 99.96%
__ Questions ___________________________________________________________
Total 4.64M 0.1/s
QC Hits 2.90M 0.1/s %Total: 62.36
Com_ 731.23k 0.0/s 15.75
DMS 581.08k 0.0/s 12.52
COM_QUIT 436.23k 0.0/s 9.40
-Unknown 1.22k 0.0/s 0.03
Slow 662 0.0/s 0.01 %DMS: 0.11
DMS 581.08k 0.0/s 12.52
SELECT 544.30k 0.0/s 11.72 93.67
UPDATE 25.17k 0.0/s 0.54 4.33
INSERT 6.46k 0.0/s 0.14 1.11
DELETE 5.15k 0.0/s 0.11 0.89
REPLACE 2 0.0/s 0.00 0.00
Com_ 731.23k 0.0/s 15.75
change_db 357.43k 0.0/s 7.70
set_option 153.06k 0.0/s 3.30
show_proces 62.58k 0.0/s 1.35
__ SELECT and Sort _____________________________________________________
Scan 52.50k 0.0/s %SELECT: 9.64
Range 7.07k 0.0/s 1.30
Full join 1 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 7.34k 0.0/s
Sort range 196.71k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 7.68M of 16.00M %Used: 47.99
Block Fragmnt 8.33%
Hits 2.90M 0.1/s
Inserts 96.92k 0.0/s
Insrt:Prune 96.92k:1 0.0/s
Hit:Insert 29.87:1
__ Table Locks _________________________________________________________
Waited 115 0.0/s %Total: 0.01
Immediate 833.91k 0.0/s
__ Tables ______________________________________________________________
Open 151 of 1024 %Cache: 14.75
Opened 281 0.0/s
__ Connections _________________________________________________________
Max used 24 of 100 %Max: 24.00
Total 436.33k 0.0/s
__ Created Temp ________________________________________________________
Disk table 5.09k 0.0/s
Table 7.09k 0.0/s
File 4 0.0/s
__ Threads _____________________________________________________________
Running 1 of 1
Cached 3 of 4 %Hit: 99.82
Created 765 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 205 0.0/s
Connects 791 0.0/s
__ Bytes _______________________________________________________________
Sent 51.41M 1.4/s
Received 652.78M 17.4/s