mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 117 14:14:9     Wed Apr 16 15:02:25 2014

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current      46.86M            %Usage:  36.61
Write hit      69.06%
Read hit       98.18%

__ Questions ___________________________________________________________
Total           4.61G   453.8/s
  QC Hits       4.03G   397.0/s  %Total:  87.48
  DMS         324.46M    31.9/s            7.04
  Com_        219.24M    21.6/s            4.76
  COM_QUIT     35.89M     3.5/s            0.78
  -Unknown      2.35M     0.2/s            0.05
Slow            8.54k     0.0/s            0.00  %DMS:   0.00
DMS           324.46M    31.9/s            7.04
  SELECT      271.86M    26.8/s            5.90         83.79
  UPDATE       26.78M     2.6/s            0.58          8.25
  INSERT       17.69M     1.7/s            0.38          5.45
  DELETE        7.99M     0.8/s            0.17          2.46
  REPLACE     139.68k     0.0/s            0.00          0.04
Com_          219.24M    21.6/s            4.76
  set_option   88.63M     8.7/s            1.92
  change_db    52.22M     5.1/s            1.13
  show_fields  27.90M     2.7/s            0.61

__ SELECT and Sort _____________________________________________________
Scan           86.61M     8.5/s %SELECT:  31.86
Range          26.90M     2.6/s            9.89
Full join       2.33M     0.2/s            0.86
Range check   732.13k     0.1/s            0.27
Full rng join  59.61k     0.0/s            0.02
Sort scan      21.07M     2.1/s
Sort range     18.16M     1.8/s
Sort mrg pass 188.94k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  203.97M of 256.00M  %Used:  79.67
Block Fragmnt  12.54%
Hits            4.03G   397.0/s
Inserts       221.07M    21.8/s
Insrt:Prune    2.57:1    13.3/s
Hit:Insert    18.25:1

__ Table Locks _________________________________________________________
Waited        121.30k     0.0/s  %Total:   0.03
Immediate     374.70M    36.9/s

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

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

__ Created Temp ________________________________________________________
Disk table     36.45M     3.6/s
Table          71.94M     7.1/s
File          375.47k     0.0/s

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

__ Aborted _____________________________________________________________
Clients        22.36k     0.0/s
Connects      176.65k     0.0/s

__ Bytes _______________________________________________________________
Sent           17.24T    1.7M/s
Received      705.50G   69.4k/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.03
  Misc            237                      0.48
  Latched                                  0.00
Reads          28.28G    2.8k/s
  From file    11.06M     1.1/s            0.04
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        105.80M    10.4/s
Flushes        16.56M     1.6/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits            1863     0.0/s
Current             0
Time acquiring
  Total         57209 ms
  Average          30 ms
  Max           17737 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        11.22M     1.1/s
  Writes       25.49M     2.5/s
  fsync         8.68M     0.9/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     282.49k     0.0/s
  Read         14.88M     1.5/s
  Written      16.56M     1.6/s

Rows
  Deleted       2.69M     0.3/s
  Inserted      3.19M     0.3/s
  Read         27.80G    2.7k/s
  Updated       5.21M     0.5/s