mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 337 18:8:12     Sat Nov 22 17:56:28 2014

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current      37.73M            %Usage:  29.48
Write hit      62.54%
Read hit       97.84%

__ Questions ___________________________________________________________
Total          14.72G   504.3/s
  QC Hits      12.82G   439.4/s  %Total:  87.14
  DMS           1.02G    34.8/s            6.90
  Com_        780.27M    26.7/s            5.30
  COM_QUIT    101.63M     3.5/s            0.69
  -Unknown      4.76M     0.2/s            0.03
Slow           22.68k     0.0/s            0.00  %DMS:   0.00
DMS             1.02G    34.8/s            6.90
  SELECT      863.48M    29.6/s            5.87         85.00
  UPDATE       74.41M     2.5/s            0.51          7.32
  INSERT       56.51M     1.9/s            0.38          5.56
  DELETE       21.02M     0.7/s            0.14          2.07
  REPLACE     382.93k     0.0/s            0.00          0.04
Com_          780.27M    26.7/s            5.30
  set_option  355.40M    12.2/s            2.42
  change_db   190.53M     6.5/s            1.29
  show_fields  69.82M     2.4/s            0.47

__ SELECT and Sort _____________________________________________________
Scan          262.38M     9.0/s %SELECT:  30.39
Range          75.04M     2.6/s            8.69
Full join       3.83M     0.1/s            0.44
Range check   842.97k     0.0/s            0.10
Full rng join 184.11k     0.0/s            0.02
Sort scan      61.98M     2.1/s
Sort range     62.15M     2.1/s
Sort mrg pass 569.41k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  196.68M of 256.00M  %Used:  76.83
Block Fragmnt  13.78%
Hits           12.82G   439.4/s
Inserts       670.86M    23.0/s
Insrt:Prune    2.61:1    14.2/s
Hit:Insert    19.11:1

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

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

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

__ Created Temp ________________________________________________________
Disk table    125.07M     4.3/s
Table         225.90M     7.7/s
File            1.13M     0.0/s

__ Threads _____________________________________________________________
Running             1 of    6
Cached             44 of   50      %Hit:    100
Created           593     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients       181.89k     0.0/s
Connects      540.14k     0.0/s

__ Bytes _______________________________________________________________
Sent           50.46T    1.7M/s
Received        2.24T   76.8k/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.01
  Misc            191                      0.39
  Latched                                  0.00
Reads         116.25G    4.0k/s
  From file    31.78M     1.1/s            0.03
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        186.15M     6.4/s
Flushes        28.29M     1.0/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        32.20M     1.1/s
  Writes       43.40M     1.5/s
  fsync        14.61M     0.5/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     432.45k     0.0/s
  Read         43.14M     1.5/s
  Written      28.29M     1.0/s

Rows
  Deleted       4.65M     0.2/s
  Inserted      6.37M     0.2/s
  Read        116.25G    4.0k/s
  Updated       9.53M     0.3/s