mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 150 1:26:30     Fri Feb  3 17:52:27 2012

__ Key _________________________________________________________________
Buffer used    31.71M of 128.00M  %Used:  24.78
  Current      33.79M            %Usage:  26.40
Write hit      86.84%
Read hit       99.48%

__ Questions ___________________________________________________________
Total           1.02G    78.5/s
  QC Hits     547.52M    42.2/s  %Total:  53.77
  DMS         270.73M    20.9/s           26.59
  Com_        172.17M    13.3/s           16.91
  COM_QUIT     36.80M     2.8/s            3.61
  -Unknown      8.91M     0.7/s            0.88
Slow           30.64k     0.0/s            0.00  %DMS:   0.01
DMS           270.73M    20.9/s           26.59
  SELECT      230.33M    17.8/s           22.62         85.08
  UPDATE       26.08M     2.0/s            2.56          9.63
  INSERT        8.64M     0.7/s            0.85          3.19
  DELETE        5.53M     0.4/s            0.54          2.04
  REPLACE     151.91k     0.0/s            0.01          0.06
Com_          172.17M    13.3/s           16.91
  change_db    56.37M     4.3/s            5.54
  set_option   40.04M     3.1/s            3.93
  show_fields  17.00M     1.3/s            1.67

__ SELECT and Sort _____________________________________________________
Scan           74.66M     5.8/s %SELECT:  32.42
Range          15.23M     1.2/s            6.61
Full join     776.51k     0.1/s            0.34
Range check    44.75k     0.0/s            0.02
Full rng join  26.95k     0.0/s            0.01
Sort scan      15.77M     1.2/s
Sort range     16.60M     1.3/s
Sort mrg pass 250.64k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  211.71M of 256.00M  %Used:  82.70
Block Fragmnt  11.52%
Hits          547.52M    42.2/s
Inserts       200.75M    15.5/s
Insrt:Prune    3.31:1    10.8/s
Hit:Insert     2.73:1

__ Table Locks _________________________________________________________
Waited        369.93k     0.0/s  %Total:   0.12
Immediate     308.61M    23.8/s

__ Tables ______________________________________________________________
Open             1024 of 1024    %Cache: 100.00
Opened         24.17M     1.9/s

__ Connections _________________________________________________________
Max used          501 of  500      %Max: 100.20
Total          36.81M     2.8/s

__ Created Temp ________________________________________________________
Disk table     27.30M     2.1/s
Table          61.45M     4.7/s
File          244.74k     0.0/s

__ Threads _____________________________________________________________
Running             1 of    6
Cached             45 of   50      %Hit:    100
Created         1.72k     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients        16.18k     0.0/s
Connects      383.74k     0.0/s

__ Bytes _______________________________________________________________
Sent           10.44T  805.2k/s
Received      226.62G   17.5k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         383.95M of 383.98M  %Used:  99.99
Read ratio      0.001
Pages
  Free              2            %Total:   0.01
  Data         24.02k                     97.73 %Drty:   0.00
  Misc            557                      2.27
  Latched                                  0.00
Reads           3.02G   232.5/s
  From file     2.31M     0.2/s            0.08
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        154.53M    11.9/s
Flushes         4.48M     0.3/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits             688     0.0/s
Current             0
Time acquiring
  Total       3631461 ms
  Average        5278 ms
  Max          121843 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         2.38M     0.2/s
  Writes        7.55M     0.6/s
  fsync         3.21M     0.2/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     208.58k     0.0/s
  Read          3.97M     0.3/s
  Written       4.48M     0.3/s

Rows
  Deleted      11.54M     0.9/s
  Inserted     19.57M     1.5/s
  Read          1.15G    89.0/s
  Updated       1.69M     0.1/s