mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 315 4:0:26      Fri Oct 31 04:48:42 2014

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current      29.83M            %Usage:  23.31
Write hit      63.02%
Read hit       97.83%

__ Questions ___________________________________________________________
Total          13.52G   496.5/s
  QC Hits      11.77G   432.4/s  %Total:  87.09
  DMS         938.84M    34.5/s            6.94
  Com_        716.85M    26.3/s            5.30
  COM_QUIT     94.23M     3.5/s            0.70
  -Unknown      4.56M     0.2/s            0.03
Slow           21.37k     0.0/s            0.00  %DMS:   0.00
DMS           938.84M    34.5/s            6.94
  SELECT      798.70M    29.3/s            5.91         85.07
  UPDATE       69.35M     2.5/s            0.51          7.39
  INSERT       50.61M     1.9/s            0.37          5.39
  DELETE       19.82M     0.7/s            0.15          2.11
  REPLACE     370.16k     0.0/s            0.00          0.04
Com_          716.85M    26.3/s            5.30
  set_option  323.59M    11.9/s            2.39
  change_db   175.05M     6.4/s            1.29
  show_fields  65.70M     2.4/s            0.49

__ SELECT and Sort _____________________________________________________
Scan          244.00M     9.0/s %SELECT:  30.55
Range          69.73M     2.6/s            8.73
Full join       3.68M     0.1/s            0.46
Range check   831.72k     0.0/s            0.10
Full rng join 172.36k     0.0/s            0.02
Sort scan      57.60M     2.1/s
Sort range     57.45M     2.1/s
Sort mrg pass 539.04k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  220.32M of 256.00M  %Used:  86.06
Block Fragmnt  13.04%
Hits           11.77G   432.4/s
Inserts       622.31M    22.9/s
Insrt:Prune    2.60:1    14.0/s
Hit:Insert    18.92:1

__ Table Locks _________________________________________________________
Waited        290.42k     0.0/s  %Total:   0.03
Immediate       1.01G    36.9/s

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

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

__ Created Temp ________________________________________________________
Disk table    115.36M     4.2/s
Table         209.68M     7.7/s
File            1.07M     0.0/s

__ Threads _____________________________________________________________
Running             2 of   10
Cached             40 of   50      %Hit:    100
Created           535     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients       138.89k     0.0/s
Connects      517.87k     0.0/s

__ Bytes _______________________________________________________________
Sent           46.32T    1.7M/s
Received        2.06T   75.6k/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.96k                     99.61 %Drty:   0.00
  Misc            194                      0.39
  Latched                                  0.00
Reads         105.21G    3.9k/s
  From file    29.60M     1.1/s            0.03
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        180.58M     6.6/s
Flushes        27.68M     1.0/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        29.99M     1.1/s
  Writes       42.17M     1.5/s
  fsync        14.21M     0.5/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     414.91k     0.0/s
  Read         40.17M     1.5/s
  Written      27.68M     1.0/s

Rows
  Deleted       4.48M     0.2/s
  Inserted      6.06M     0.2/s
  Read        105.19G    3.9k/s
  Updated       9.08M     0.3/s