mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 365 18:43:29    Sat Dec 20 18:31:45 2014

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current      32.81M            %Usage:  25.63
Write hit      62.23%
Read hit       97.81%

__ Questions ___________________________________________________________
Total          16.14G   510.7/s
  QC Hits      14.07G   445.2/s  %Total:  87.17
  DMS           1.11G    35.0/s            6.86
  Com_        857.01M    27.1/s            5.31
  COM_QUIT    110.84M     3.5/s            0.69
  -Unknown      5.01M     0.2/s            0.03
Slow           24.29k     0.0/s            0.00  %DMS:   0.00
DMS             1.11G    35.0/s            6.86
  SELECT      943.25M    29.8/s            5.84         85.19
  UPDATE       80.25M     2.5/s            0.50          7.25
  INSERT       60.89M     1.9/s            0.38          5.50
  DELETE       22.49M     0.7/s            0.14          2.03
  REPLACE     397.25k     0.0/s            0.00          0.04
Com_          857.01M    27.1/s            5.31
  set_option  394.38M    12.5/s            2.44
  change_db   208.12M     6.6/s            1.29
  show_fields  75.01M     2.4/s            0.46

__ SELECT and Sort _____________________________________________________
Scan          285.05M     9.0/s %SELECT:  30.22
Range          81.05M     2.6/s            8.59
Full join       3.99M     0.1/s            0.42
Range check   857.77k     0.0/s            0.09
Full rng join 198.50k     0.0/s            0.02
Sort scan      67.33M     2.1/s
Sort range     68.12M     2.2/s
Sort mrg pass 613.70k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  195.70M of 256.00M  %Used:  76.45
Block Fragmnt  12.80%
Hits           14.07G   445.2/s
Inserts       729.12M    23.1/s
Insrt:Prune    2.62:1    14.3/s
Hit:Insert    19.30:1

__ Table Locks _________________________________________________________
Waited        328.05k     0.0/s  %Total:   0.03
Immediate       1.17G    37.1/s

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

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

__ Created Temp ________________________________________________________
Disk table    137.19M     4.3/s
Table         246.52M     7.8/s
File            1.22M     0.0/s

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

__ Aborted _____________________________________________________________
Clients       234.10k     0.0/s
Connects      563.14k     0.0/s

__ Bytes _______________________________________________________________
Sent           55.57T    1.8M/s
Received        2.44T   77.4k/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.91k                     99.50 %Drty:   0.03
  Misc            245                      0.50
  Latched                                  0.00
Reads         128.15G    4.1k/s
  From file    34.49M     1.1/s            0.03
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        192.86M     6.1/s
Flushes        29.10M     0.9/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits            3012     0.0/s
Current             0
Time acquiring
  Total        130422 ms
  Average          43 ms
  Max           31338 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        34.93M     1.1/s
  Writes       44.98M     1.4/s
  fsync        15.14M     0.5/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     449.69k     0.0/s
  Read         46.92M     1.5/s
  Written      29.10M     0.9/s

Rows
  Deleted       4.87M     0.2/s
  Inserted      6.73M     0.2/s
  Read        128.18G    4.1k/s
  Updated      10.05M     0.3/s