mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 255 22:52:55    Mon Sep  1 23:41:11 2014

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current      38.25M            %Usage:  29.88
Write hit      64.24%
Read hit       97.92%

__ Questions ___________________________________________________________
Total          10.59G   479.1/s
  QC Hits       9.21G   416.5/s  %Total:  86.94
  DMS         756.71M    34.2/s            7.14
  Com_        553.43M    25.0/s            5.22
  COM_QUIT     76.51M     3.5/s            0.72
  -Unknown      3.42M     0.2/s            0.03
Slow           17.51k     0.0/s            0.00  %DMS:   0.00
DMS           756.71M    34.2/s            7.14
  SELECT      644.18M    29.1/s            6.08         85.13
  UPDATE       56.70M     2.6/s            0.54          7.49
  INSERT       39.12M     1.8/s            0.37          5.17
  DELETE       16.37M     0.7/s            0.15          2.16
  REPLACE     340.02k     0.0/s            0.00          0.04
Com_          553.43M    25.0/s            5.22
  set_option  244.35M    11.0/s            2.31
  change_db   133.35M     6.0/s            1.26
  show_fields  54.97M     2.5/s            0.52

__ SELECT and Sort _____________________________________________________
Scan          197.21M     8.9/s %SELECT:  30.61
Range          56.89M     2.6/s            8.83
Full join       3.24M     0.1/s            0.50
Range check   800.92k     0.0/s            0.12
Full rng join 140.98k     0.0/s            0.02
Sort scan      46.65M     2.1/s
Sort range     46.37M     2.1/s
Sort mrg pass 432.62k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  194.26M of 256.00M  %Used:  75.88
Block Fragmnt  13.94%
Hits            9.21G   416.5/s
Inserts       508.94M    23.0/s
Insrt:Prune    2.60:1    14.2/s
Hit:Insert    18.10:1

__ Table Locks _________________________________________________________
Waited        239.13k     0.0/s  %Total:   0.03
Immediate     822.02M    37.2/s

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

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

__ Created Temp ________________________________________________________
Disk table     89.95M     4.1/s
Table         166.86M     7.5/s
File          859.37k     0.0/s

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

__ Aborted _____________________________________________________________
Clients        40.52k     0.0/s
Connects      394.89k     0.0/s

__ Bytes _______________________________________________________________
Sent           36.94T    1.7M/s
Received        1.63T   73.5k/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.92k                     99.52 %Drty:   0.02
  Misc            234                      0.48
  Latched                                  0.00
Reads          81.31G    3.7k/s
  From file    24.13M     1.1/s            0.03
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        165.56M     7.5/s
Flushes        25.82M     1.2/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits            2728     0.0/s
Current             0
Time acquiring
  Total         79031 ms
  Average          28 ms
  Max           17737 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        24.45M     1.1/s
  Writes       38.58M     1.7/s
  fsync        13.02M     0.6/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     372.66k     0.0/s
  Read         32.66M     1.5/s
  Written      25.82M     1.2/s

Rows
  Deleted       3.98M     0.2/s
  Inserted      5.11M     0.2/s
  Read         81.18G    3.7k/s
  Updated       8.04M     0.4/s