mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 218 3:19:57     Sat Jul 26 04:08:13 2014

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current      31.48M            %Usage:  24.59
Write hit      64.98%
Read hit       98.03%

__ Questions ___________________________________________________________
Total           8.63G   457.8/s
  QC Hits       7.47G   396.6/s  %Total:  86.63
  DMS         642.08M    34.1/s            7.44
  Com_        448.68M    23.8/s            5.20
  COM_QUIT     65.48M     3.5/s            0.76
  -Unknown      3.06M     0.2/s            0.04
Slow           15.25k     0.0/s            0.00  %DMS:   0.00
DMS           642.08M    34.1/s            7.44
  SELECT      545.24M    28.9/s            6.32         84.92
  UPDATE       49.24M     2.6/s            0.57          7.67
  INSERT       33.15M     1.8/s            0.38          5.16
  DELETE       14.15M     0.8/s            0.16          2.20
  REPLACE     293.94k     0.0/s            0.00          0.05
Com_          448.68M    23.8/s            5.20
  set_option  193.77M    10.3/s            2.25
  change_db   107.22M     5.7/s            1.24
  show_fields  47.86M     2.5/s            0.55

__ SELECT and Sort _____________________________________________________
Scan          166.01M     8.8/s %SELECT:  30.45
Range          48.95M     2.6/s            8.98
Full join       2.97M     0.2/s            0.54
Range check   779.99k     0.0/s            0.14
Full rng join 117.57k     0.0/s            0.02
Sort scan      39.63M     2.1/s
Sort range     39.09M     2.1/s
Sort mrg pass 367.75k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  196.94M of 256.00M  %Used:  76.93
Block Fragmnt  13.75%
Hits            7.47G   396.6/s
Inserts       435.43M    23.1/s
Insrt:Prune    2.62:1    14.3/s
Hit:Insert    17.17:1

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

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

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

__ Created Temp ________________________________________________________
Disk table     73.42M     3.9/s
Table         138.95M     7.4/s
File          730.52k     0.0/s

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

__ Aborted _____________________________________________________________
Clients        28.65k     0.0/s
Connects      350.94k     0.0/s

__ Bytes _______________________________________________________________
Sent           31.38T    1.7M/s
Received        1.33T   70.8k/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.52 %Drty:   0.00
  Misc            236                      0.48
  Latched                                  0.00
Reads          67.69G    3.6k/s
  From file    20.74M     1.1/s            0.03
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        153.73M     8.2/s
Flushes        24.15M     1.3/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        21.02M     1.1/s
  Writes       35.86M     1.9/s
  fsync        12.10M     0.6/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     346.33k     0.0/s
  Read         28.01M     1.5/s
  Written      24.15M     1.3/s

Rows
  Deleted       3.75M     0.2/s
  Inserted      4.58M     0.2/s
  Read         67.47G    3.6k/s
  Updated       7.28M     0.4/s