mysqlreport Live Demonstration

MySQL 4.1.25-Debian_mt1  uptime 259 10:40:31    Thu Mar 11 10:26:07 2010

__ Key _________________________________________________________________
Buffer used   788.00k of  32.00M  %Used:   2.40
  Current       4.35M            %Usage:  13.58
Write hit      57.01%
Read hit       99.95%

__ Questions ___________________________________________________________
Total           2.26M     0.1/s
  QC Hits       1.41M     0.1/s  %Total:  62.42
  Com_        348.98k     0.0/s           15.43
  DMS         286.18k     0.0/s           12.65
  COM_QUIT    215.04k     0.0/s            9.51
  -Unknown        273     0.0/s            0.01
Slow              205     0.0/s            0.01  %DMS:   0.07
DMS           286.18k     0.0/s           12.65
  SELECT      271.93k     0.0/s           12.02         95.02
  UPDATE       12.61k     0.0/s            0.56          4.41
  INSERT        1.16k     0.0/s            0.05          0.41
  DELETE          473     0.0/s            0.02          0.17
  REPLACE           2     0.0/s            0.00          0.00
Com_          348.98k     0.0/s           15.43
  change_db   167.91k     0.0/s            7.42
  set_option   65.83k     0.0/s            2.91
  show_proces  37.36k     0.0/s            1.65

__ SELECT and Sort _____________________________________________________
Scan           32.93k     0.0/s %SELECT:  12.11
Range           4.11k     0.0/s            1.51
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       3.77k     0.0/s
Sort range    112.85k     0.0/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage    2.64M of  16.00M  %Used:  16.50
Block Fragmnt   3.84%
Hits            1.41M     0.1/s
Inserts        36.85k     0.0/s
Insrt:Prune  36.85k:1     0.0/s
Hit:Insert    38.31:1

__ Table Locks _________________________________________________________
Waited             21     0.0/s  %Total:   0.00
Immediate     455.55k     0.0/s

__ Tables ______________________________________________________________
Open              114 of 1024    %Cache:  11.13
Opened            244     0.0/s

__ Connections _________________________________________________________
Max used           15 of  100      %Max:  15.00
Total         215.08k     0.0/s

__ Created Temp ________________________________________________________
Disk table      2.55k     0.0/s
Table           3.59k     0.0/s
File                4     0.0/s

__ Threads _____________________________________________________________
Running             1 of    1
Cached              3 of    4      %Hit:  99.94
Created           134     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients            67     0.0/s
Connects            9     0.0/s

__ Bytes _______________________________________________________________
Sent            2.61G   116.5/s
Received      320.45M    14.3/s