mysqlreport Live Demonstration
MySQL 4.1.11-Debian_4sa uptime 235 10:7:34 Wed Jul 23 11:30:26 2008
__ Key _________________________________________________________________
Buffer used 613.00k of 32.00M %Used: 1.87
Current 4.27M %Usage: 13.36
Write hit 24.14%
Read hit 99.82%
__ Questions ___________________________________________________________
Total 4.39M 0.2/s
QC Hits 2.58M 0.1/s %Total: 58.62
DMS 1.36M 0.1/s 30.84
Com_ 265.76k 0.0/s 6.05
COM_QUIT 197.33k 0.0/s 4.49
+Unknown 94 0.0/s 0.00
Slow 1 0.0/s 0.00 %DMS: 0.00
DMS 1.36M 0.1/s 30.84
INSERT 771.49k 0.0/s 17.56 56.92
SELECT 577.38k 0.0/s 13.14 42.60
UPDATE 5.51k 0.0/s 0.13 0.41
DELETE 959 0.0/s 0.02 0.07
REPLACE 27 0.0/s 0.00 0.00
Com_ 265.76k 0.0/s 6.05
change_db 153.87k 0.0/s 3.50
set_option 44.17k 0.0/s 1.01
show_proces 33.90k 0.0/s 0.77
__ SELECT and Sort _____________________________________________________
Scan 17.30k 0.0/s %SELECT: 3.00
Range 2.41k 0.0/s 0.42
Full join 3 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 2 0.0/s 0.00
Sort scan 5.64k 0.0/s
Sort range 11.55k 0.0/s
Sort mrg pass 4 0.0/s
__ Query Cache _________________________________________________________
Memory usage 3.36M of 16.00M %Used: 20.99
Block Fragmnt 9.72%
Hits 2.58M 0.1/s
Inserts 530.10k 0.0/s
Insrt:Prune 530.10k:1 0.0/s
Hit:Insert 4.86:1
__ Table Locks _________________________________________________________
Waited 2 0.0/s %Total: 0.00
Immediate 1.33M 0.1/s
__ Tables ______________________________________________________________
Open 142 of 1024 %Cache: 13.87
Opened 639 0.0/s
__ Connections _________________________________________________________
Max used 20 of 100 %Max: 20.00
Total 197.42k 0.0/s
__ Created Temp ________________________________________________________
Disk table 363 0.0/s
Table 17.73k 0.0/s
File 11 0.0/s
__ Threads _____________________________________________________________
Running 1 of 1
Cached 3 of 4 %Hit: 99.96
Created 71 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 174 0.0/s
Connects 15 0.0/s
__ Bytes _______________________________________________________________
Sent 2.96G 145.3/s
Received 549.34M 27.0/s