mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 220 18:46:34    Mon Jul 28 19:34:50 2014

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current      40.79M            %Usage:  31.87
Write hit      64.87%
Read hit       98.03%

__ Questions ___________________________________________________________
Total           8.74G   458.1/s
  QC Hits       7.57G   396.8/s  %Total:  86.61
  DMS         650.56M    34.1/s            7.44
  Com_        456.06M    23.9/s            5.22
  COM_QUIT     66.21M     3.5/s            0.76
  -Unknown      3.08M     0.2/s            0.04
Slow           15.43k     0.0/s            0.00  %DMS:   0.00
DMS           650.56M    34.1/s            7.44
  SELECT      552.58M    29.0/s            6.32         84.94
  UPDATE       49.77M     2.6/s            0.57          7.65
  INSERT       33.60M     1.8/s            0.38          5.16
  DELETE       14.32M     0.8/s            0.16          2.20
  REPLACE     298.32k     0.0/s            0.00          0.05
Com_          456.06M    23.9/s            5.22
  set_option  197.52M    10.4/s            2.26
  change_db   108.75M     5.7/s            1.24
  show_fields  48.39M     2.5/s            0.55

__ SELECT and Sort _____________________________________________________
Scan          168.33M     8.8/s %SELECT:  30.46
Range          49.49M     2.6/s            8.96
Full join       2.98M     0.2/s            0.54
Range check   781.68k     0.0/s            0.14
Full rng join 119.09k     0.0/s            0.02
Sort scan      40.07M     2.1/s
Sort range     39.60M     2.1/s
Sort mrg pass 372.42k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  195.14M of 256.00M  %Used:  76.23
Block Fragmnt  13.62%
Hits            7.57G   396.8/s
Inserts       440.93M    23.1/s
Insrt:Prune    2.62:1    14.3/s
Hit:Insert    17.16:1

__ Table Locks _________________________________________________________
Waited        216.43k     0.0/s  %Total:   0.03
Immediate     715.09M    37.5/s

__ Tables ______________________________________________________________
Open             1024 of 1024    %Cache: 100.00
Opened         81.43M     4.3/s

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

__ Created Temp ________________________________________________________
Disk table     74.66M     3.9/s
Table         141.00M     7.4/s
File          739.81k     0.0/s

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

__ Aborted _____________________________________________________________
Clients        28.82k     0.0/s
Connects      354.33k     0.0/s

__ Bytes _______________________________________________________________
Sent           31.76T    1.7M/s
Received        1.35T   70.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.91k                     99.50 %Drty:   0.00
  Misc            243                      0.49
  Latched                                  0.00
Reads          68.62G    3.6k/s
  From file    21.03M     1.1/s            0.03
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        155.11M     8.1/s
Flushes        24.32M     1.3/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits            2551     0.0/s
Current             0
Time acquiring
  Total         69556 ms
  Average          27 ms
  Max           17737 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        21.32M     1.1/s
  Writes       36.09M     1.9/s
  fsync        12.17M     0.6/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     348.74k     0.0/s
  Read         28.40M     1.5/s
  Written      24.32M     1.3/s

Rows
  Deleted       3.78M     0.2/s
  Inserted      4.67M     0.2/s
  Read         68.42G    3.6k/s
  Updated       7.33M     0.4/s