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