mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 309 5:32:16     Sat Oct 25 06:20:32 2014

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current      34.25M            %Usage:  26.76
Write hit      63.93%
Read hit       97.82%

__ Questions ___________________________________________________________
Total          13.10G   490.4/s
  QC Hits      11.40G   426.7/s  %Total:  87.01
  DMS         914.85M    34.2/s            6.98
  Com_        699.76M    26.2/s            5.34
  COM_QUIT     92.19M     3.5/s            0.70
  -Unknown      4.51M     0.2/s            0.03
Slow           21.00k     0.0/s            0.00  %DMS:   0.00
DMS           914.85M    34.2/s            6.98
  SELECT      780.30M    29.2/s            5.96         85.29
  UPDATE       67.82M     2.5/s            0.52          7.41
  INSERT       46.86M     1.8/s            0.36          5.12
  DELETE       19.49M     0.7/s            0.15          2.13
  REPLACE     366.69k     0.0/s            0.00          0.04
Com_          699.76M    26.2/s            5.34
  set_option  314.90M    11.8/s            2.40
  change_db   170.93M     6.4/s            1.30
  show_fields  64.62M     2.4/s            0.49

__ SELECT and Sort _____________________________________________________
Scan          239.06M     8.9/s %SELECT:  30.64
Range          68.13M     2.5/s            8.73
Full join       3.63M     0.1/s            0.47
Range check   827.74k     0.0/s            0.11
Full rng join 169.35k     0.0/s            0.02
Sort scan      56.36M     2.1/s
Sort range     55.89M     2.1/s
Sort mrg pass 525.53k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  198.90M of 256.00M  %Used:  77.70
Block Fragmnt  12.68%
Hits           11.40G   426.7/s
Inserts       608.25M    22.8/s
Insrt:Prune    2.59:1    14.0/s
Hit:Insert    18.74:1

__ Table Locks _________________________________________________________
Waited        277.25k     0.0/s  %Total:   0.03
Immediate     981.68M    36.7/s

__ Tables ______________________________________________________________
Open             1024 of 1024    %Cache: 100.00
Opened        112.32M     4.2/s

__ Connections _________________________________________________________
Max used          181 of  500      %Max:  36.20
Total          92.26M     3.5/s

__ Created Temp ________________________________________________________
Disk table    112.75M     4.2/s
Table         205.23M     7.7/s
File            1.04M     0.0/s

__ Threads _____________________________________________________________
Running             2 of    7
Cached             43 of   50      %Hit:    100
Created           514     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients       128.04k     0.0/s
Connects      509.50k     0.0/s

__ Bytes _______________________________________________________________
Sent           45.18T    1.7M/s
Received        1.98T   74.2k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         767.97M of 767.98M  %Used: 100.00
Read ratio      0.000
Pages
  Free              1            %Total:   0.00
  Data         48.95k                     99.59 %Drty:   0.00
  Misc            199                      0.40
  Latched                                  0.00
Reads         102.10G    3.8k/s
  From file    29.00M     1.1/s            0.03
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        179.22M     6.7/s
Flushes        27.52M     1.0/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits            2877     0.0/s
Current             0
Time acquiring
  Total        127542 ms
  Average          44 ms
  Max           31338 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        29.38M     1.1/s
  Writes       41.83M     1.6/s
  fsync        14.09M     0.5/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     411.11k     0.0/s
  Read         39.35M     1.5/s
  Written      27.52M     1.0/s

Rows
  Deleted       4.43M     0.2/s
  Inserted      5.99M     0.2/s
  Read        102.08G    3.8k/s
  Updated       8.97M     0.3/s