mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 253 4:22:14     Sat Aug 30 05:10:30 2014

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current      31.83M            %Usage:  24.86
Write hit      64.24%
Read hit       97.93%

__ Questions ___________________________________________________________
Total          10.48G   479.3/s
  QC Hits       9.12G   416.8/s  %Total:  86.96
  DMS         748.84M    34.2/s            7.14
  Com_        545.60M    24.9/s            5.20
  COM_QUIT     75.72M     3.5/s            0.72
  -Unknown      3.40M     0.2/s            0.03
Slow           17.33k     0.0/s            0.00  %DMS:   0.00
DMS           748.84M    34.2/s            7.14
  SELECT      637.34M    29.1/s            6.08         85.11
  UPDATE       56.17M     2.6/s            0.54          7.50
  INSERT       38.77M     1.8/s            0.37          5.18
  DELETE       16.22M     0.7/s            0.15          2.17
  REPLACE     337.36k     0.0/s            0.00          0.05
Com_          545.60M    24.9/s            5.20
  set_option  240.50M    11.0/s            2.29
  change_db   131.48M     6.0/s            1.25
  show_fields  54.44M     2.5/s            0.52

__ SELECT and Sort _____________________________________________________
Scan          194.86M     8.9/s %SELECT:  30.57
Range          56.34M     2.6/s            8.84
Full join       3.22M     0.1/s            0.50
Range check   799.15k     0.0/s            0.13
Full rng join 139.37k     0.0/s            0.02
Sort scan      46.18M     2.1/s
Sort range     45.92M     2.1/s
Sort mrg pass 428.95k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  184.53M of 256.00M  %Used:  72.08
Block Fragmnt  15.23%
Hits            9.12G   416.8/s
Inserts       503.92M    23.0/s
Insrt:Prune    2.60:1    14.2/s
Hit:Insert    18.09:1

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

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

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

__ Created Temp ________________________________________________________
Disk table     88.72M     4.1/s
Table         164.77M     7.5/s
File          852.04k     0.0/s

__ Threads _____________________________________________________________
Running             2 of    6
Cached             45 of   50      %Hit:    100
Created           402     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients        36.74k     0.0/s
Connects      391.82k     0.0/s

__ Bytes _______________________________________________________________
Sent           36.55T    1.7M/s
Received        1.61T   73.6k/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.90k                     99.50 %Drty:   0.00
  Misc            246                      0.50
  Latched                                  0.00
Reads          80.22G    3.7k/s
  From file    23.89M     1.1/s            0.03
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        164.95M     7.5/s
Flushes        25.71M     1.2/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits            2709     0.0/s
Current             0
Time acquiring
  Total         78895 ms
  Average          29 ms
  Max           17737 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        24.20M     1.1/s
  Writes       38.41M     1.8/s
  fsync        12.95M     0.6/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     371.46k     0.0/s
  Read         32.30M     1.5/s
  Written      25.71M     1.2/s

Rows
  Deleted       3.97M     0.2/s
  Inserted      5.09M     0.2/s
  Read         80.09G    3.7k/s
  Updated       8.00M     0.4/s