mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 125 18:1:16     Thu Apr 24 18:49:32 2014

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current      31.03M            %Usage:  24.24
Write hit      68.81%
Read hit       98.15%

__ Questions ___________________________________________________________
Total           4.80G   442.0/s
  QC Hits       4.19G   385.2/s  %Total:  87.15
  DMS         347.53M    32.0/s            7.24
  Com_        233.70M    21.5/s            4.87
  COM_QUIT     38.23M     3.5/s            0.80
  -Unknown      2.42M     0.2/s            0.05
Slow            9.14k     0.0/s            0.00  %DMS:   0.00
DMS           347.53M    32.0/s            7.24
  SELECT      291.79M    26.9/s            6.08         83.96
  UPDATE       28.16M     2.6/s            0.59          8.10
  INSERT       18.90M     1.7/s            0.39          5.44
  DELETE        8.53M     0.8/s            0.18          2.45
  REPLACE     151.81k     0.0/s            0.00          0.04
Com_          233.70M    21.5/s            4.87
  set_option   94.38M     8.7/s            1.97
  change_db    56.03M     5.2/s            1.17
  show_fields  29.54M     2.7/s            0.62

__ SELECT and Sort _____________________________________________________
Scan           92.09M     8.5/s %SELECT:  31.56
Range          28.50M     2.6/s            9.77
Full join       2.38M     0.2/s            0.81
Range check   736.45k     0.1/s            0.25
Full rng join  64.11k     0.0/s            0.02
Sort scan      22.38M     2.1/s
Sort range     19.45M     1.8/s
Sort mrg pass 201.37k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  202.13M of 256.00M  %Used:  78.96
Block Fragmnt  12.39%
Hits            4.19G   385.2/s
Inserts       237.16M    21.8/s
Insrt:Prune    2.58:1    13.4/s
Hit:Insert    17.65:1

__ Table Locks _________________________________________________________
Waited        125.20k     0.0/s  %Total:   0.03
Immediate     399.69M    36.8/s

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

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

__ Created Temp ________________________________________________________
Disk table     38.68M     3.6/s
Table          76.32M     7.0/s
File          400.17k     0.0/s

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

__ Aborted _____________________________________________________________
Clients        22.61k     0.0/s
Connects      205.14k     0.0/s

__ Bytes _______________________________________________________________
Sent           18.22T    1.7M/s
Received      737.16G   67.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.90k                     99.48 %Drty:   0.00
  Misc            253                      0.51
  Latched                                  0.00
Reads          31.06G    2.9k/s
  From file    11.86M     1.1/s            0.04
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        110.57M    10.2/s
Flushes        17.27M     1.6/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        12.02M     1.1/s
  Writes       26.37M     2.4/s
  fsync         8.97M     0.8/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     292.64k     0.0/s
  Read         15.95M     1.5/s
  Written      17.27M     1.6/s

Rows
  Deleted       2.80M     0.3/s
  Inserted      3.33M     0.3/s
  Read         30.62G    2.8k/s
  Updated       5.38M     0.5/s