mysqlreport Live Demonstration
MySQL 4.1.25-Debian_mt1 uptime 9 8:9:4 Sat Jul 4 08:54:40 2009
__ Key _________________________________________________________________
Buffer used 23.00k of 32.00M %Used: 0.07
Current 3.71M %Usage: 11.58
Write hit 100.00%
Read hit 99.95%
__ Questions ___________________________________________________________
Total 179.27k 0.2/s
QC Hits 133.85k 0.2/s %Total: 74.66
Com_ 16.33k 0.0/s 9.11
DMS 15.13k 0.0/s 8.44
COM_QUIT 13.96k 0.0/s 7.79
-Unknown 12 0.0/s 0.01
Slow 0 0/s 0.00 %DMS: 0.00
DMS 15.13k 0.0/s 8.44
SELECT 14.95k 0.0/s 8.34 98.76
UPDATE 188 0.0/s 0.10 1.24
REPLACE 0 0/s 0.00 0.00
DELETE 0 0/s 0.00 0.00
INSERT 0 0/s 0.00 0.00
Com_ 16.33k 0.0/s 9.11
change_db 12.31k 0.0/s 6.87
set_option 1.64k 0.0/s 0.92
show_proces 1.34k 0.0/s 0.75
__ SELECT and Sort _____________________________________________________
Scan 5.01k 0.0/s %SELECT: 33.51
Range 318 0.0/s 2.13
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 102 0.0/s
Sort range 5.01k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 1.79M of 16.00M %Used: 11.16
Block Fragmnt 0.04%
Hits 133.85k 0.2/s
Inserts 1.30k 0.0/s
Insrt:Prune 1.30k:1 0.0/s
Hit:Insert 103.12:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 21.76k 0.0/s
__ Tables ______________________________________________________________
Open 115 of 1024 %Cache: 11.23
Opened 121 0.0/s
__ Connections _________________________________________________________
Max used 6 of 100 %Max: 6.00
Total 13.97k 0.0/s
__ Created Temp ________________________________________________________
Disk table 97 0.0/s
Table 98 0.0/s
File 4 0.0/s
__ Threads _____________________________________________________________
Running 1 of 1
Cached 3 of 4 %Hit: 99.93
Created 10 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 2 0.0/s
Connects 0 0/s
__ Bytes _______________________________________________________________
Sent 376.37M 466.4/s
Received 24.18M 30.0/s