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