mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 306 5:57:0      Wed Oct 22 06:45:16 2014

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current      46.30M            %Usage:  36.17
Write hit      63.96%
Read hit       97.81%

__ Questions ___________________________________________________________
Total          12.94G   488.9/s
  QC Hits      11.25G   425.3/s  %Total:  86.99
  DMS         904.82M    34.2/s            6.99
  Com_        691.84M    26.1/s            5.35
  COM_QUIT     91.18M     3.4/s            0.70
  -Unknown      4.43M     0.2/s            0.03
Slow           20.82k     0.0/s            0.00  %DMS:   0.00
DMS           904.82M    34.2/s            6.99
  SELECT      771.71M    29.2/s            5.97         85.29
  UPDATE       67.10M     2.5/s            0.52          7.42
  INSERT       46.33M     1.8/s            0.36          5.12
  DELETE       19.32M     0.7/s            0.15          2.14
  REPLACE     365.43k     0.0/s            0.00          0.04
Com_          691.84M    26.1/s            5.35
  set_option  311.07M    11.8/s            2.40
  change_db   168.71M     6.4/s            1.30
  show_fields  64.13M     2.4/s            0.50

__ SELECT and Sort _____________________________________________________
Scan          236.92M     9.0/s %SELECT:  30.70
Range          67.40M     2.5/s            8.73
Full join       3.61M     0.1/s            0.47
Range check   826.27k     0.0/s            0.11
Full rng join 167.79k     0.0/s            0.02
Sort scan      55.79M     2.1/s
Sort range     55.27M     2.1/s
Sort mrg pass 516.64k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  194.96M of 256.00M  %Used:  76.16
Block Fragmnt  15.37%
Hits           11.25G   425.3/s
Inserts       601.74M    22.7/s
Insrt:Prune    2.59:1    13.9/s
Hit:Insert    18.70:1

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

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

__ Connections _________________________________________________________
Max used          181 of  500      %Max:  36.20
Total          91.25M     3.4/s

__ Created Temp ________________________________________________________
Disk table    111.60M     4.2/s
Table         203.29M     7.7/s
File            1.03M     0.0/s

__ Threads _____________________________________________________________
Running             1 of    5
Cached             45 of   50      %Hit:    100
Created           495     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients       122.53k     0.0/s
Connects      460.26k     0.0/s

__ Bytes _______________________________________________________________
Sent           44.68T    1.7M/s
Received        1.96T   74.0k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         767.98M of 767.98M  %Used: 100.00
Read ratio      0.000
Pages
  Free              0            %Total:   0.00
  Data         48.96k                     99.61 %Drty:   0.00
  Misc            191                      0.39
  Latched                                  0.00
Reads         100.98G    3.8k/s
  From file    28.74M     1.1/s            0.03
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        178.26M     6.7/s
Flushes        27.42M     1.0/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        29.12M     1.1/s
  Writes       41.64M     1.6/s
  fsync        14.03M     0.5/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     406.51k     0.0/s
  Read         39.01M     1.5/s
  Written      27.42M     1.0/s

Rows
  Deleted       4.40M     0.2/s
  Inserted      5.93M     0.2/s
  Read        100.95G    3.8k/s
  Updated       8.91M     0.3/s