mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 343 6:31:8      Fri Nov 28 06:19:24 2014

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current      32.25M            %Usage:  25.19
Write hit      62.55%
Read hit       97.84%

__ Questions ___________________________________________________________
Total          14.99G   505.5/s
  QC Hits      13.07G   440.6/s  %Total:  87.15
  DMS           1.03G    34.8/s            6.89
  Com_        795.32M    26.8/s            5.30
  COM_QUIT    103.32M     3.5/s            0.69
  -Unknown      4.81M     0.2/s            0.03
Slow           23.00k     0.0/s            0.00  %DMS:   0.00
DMS             1.03G    34.8/s            6.89
  SELECT      878.86M    29.6/s            5.86         85.04
  UPDATE       75.59M     2.5/s            0.50          7.31
  INSERT       57.36M     1.9/s            0.38          5.55
  DELETE       21.31M     0.7/s            0.14          2.06
  REPLACE     385.85k     0.0/s            0.00          0.04
Com_          795.32M    26.8/s            5.30
  set_option  362.92M    12.2/s            2.42
  change_db   194.07M     6.5/s            1.29
  show_fields  70.86M     2.4/s            0.47

__ SELECT and Sort _____________________________________________________
Scan          266.75M     9.0/s %SELECT:  30.35
Range          76.22M     2.6/s            8.67
Full join       3.87M     0.1/s            0.44
Range check   846.17k     0.0/s            0.10
Full rng join 187.62k     0.0/s            0.02
Sort scan      62.97M     2.1/s
Sort range     63.31M     2.1/s
Sort mrg pass 577.26k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  200.28M of 256.00M  %Used:  78.23
Block Fragmnt  14.94%
Hits           13.07G   440.6/s
Inserts       682.21M    23.0/s
Insrt:Prune    2.61:1    14.2/s
Hit:Insert    19.15:1

__ Table Locks _________________________________________________________
Waited        313.15k     0.0/s  %Total:   0.03
Immediate       1.10G    37.1/s

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

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

__ Created Temp ________________________________________________________
Disk table    127.46M     4.3/s
Table         229.94M     7.8/s
File            1.15M     0.0/s

__ Threads _____________________________________________________________
Running             1 of    3
Cached             48 of   50      %Hit:    100
Created           593     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients       191.75k     0.0/s
Connects      544.22k     0.0/s

__ Bytes _______________________________________________________________
Sent           51.45T    1.7M/s
Received        2.28T   76.9k/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.96k                     99.61 %Drty:   0.00
  Misc            190                      0.39
  Latched                                  0.00
Reads         118.92G    4.0k/s
  From file    32.30M     1.1/s            0.03
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        187.57M     6.3/s
Flushes        28.47M     1.0/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits            2944     0.0/s
Current             0
Time acquiring
  Total        127657 ms
  Average          43 ms
  Max           31338 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        32.72M     1.1/s
  Writes       43.75M     1.5/s
  fsync        14.73M     0.5/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     435.79k     0.0/s
  Read         43.87M     1.5/s
  Written      28.47M     1.0/s

Rows
  Deleted       4.70M     0.2/s
  Inserted      6.44M     0.2/s
  Read        118.91G    4.0k/s
  Updated       9.63M     0.3/s