mysqlreport Live Demonstration

MySQL 5.1.55-rel12.6     uptime 276 10:23:55    Mon Sep 22 11:12:11 2014

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current      48.06M            %Usage:  37.55
Write hit      64.09%
Read hit       97.87%

__ Questions ___________________________________________________________
Total          11.72G   490.5/s
  QC Hits      10.21G   427.6/s  %Total:  87.17
  DMS         815.46M    34.1/s            6.96
  Com_        609.44M    25.5/s            5.20
  COM_QUIT     82.24M     3.4/s            0.70
  -Unknown      3.91M     0.2/s            0.03
Slow           18.98k     0.0/s            0.00  %DMS:   0.00
DMS           815.46M    34.1/s            6.96
  SELECT      694.54M    29.1/s            5.93         85.17
  UPDATE       60.70M     2.5/s            0.52          7.44
  INSERT       42.20M     1.8/s            0.36          5.18
  DELETE       17.66M     0.7/s            0.15          2.17
  REPLACE     351.45k     0.0/s            0.00          0.04
Com_          609.44M    25.5/s            5.20
  set_option  271.32M    11.4/s            2.32
  change_db   147.34M     6.2/s            1.26
  show_fields  58.74M     2.5/s            0.50

__ SELECT and Sort _____________________________________________________
Scan          213.46M     8.9/s %SELECT:  30.73
Range          60.87M     2.5/s            8.76
Full join       3.38M     0.1/s            0.49
Range check   811.92k     0.0/s            0.12
Full rng join 151.36k     0.0/s            0.02
Sort scan      50.26M     2.1/s
Sort range     49.84M     2.1/s
Sort mrg pass 466.70k     0.0/s

__ Query Cache _________________________________________________________
Memory usage  200.38M of 256.00M  %Used:  78.27
Block Fragmnt  14.28%
Hits           10.21G   427.6/s
Inserts       545.73M    22.8/s
Insrt:Prune    2.59:1    14.0/s
Hit:Insert    18.71:1

__ Table Locks _________________________________________________________
Waited        251.34k     0.0/s  %Total:   0.03
Immediate     881.15M    36.9/s

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

__ Connections _________________________________________________________
Max used          181 of  500      %Max:  36.20
Total          82.28M     3.4/s

__ Created Temp ________________________________________________________
Disk table     98.78M     4.1/s
Table         181.72M     7.6/s
File          927.38k     0.0/s

__ Threads _____________________________________________________________
Running             1 of    8
Cached             43 of   50      %Hit:    100
Created           423     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients        70.86k     0.0/s
Connects      420.83k     0.0/s

__ Bytes _______________________________________________________________
Sent           40.05T    1.7M/s
Received        1.79T   74.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.96k                     99.60 %Drty:   0.00
  Misc            194                      0.39
  Latched                                  0.00
Reads          88.80G    3.7k/s
  From file    26.01M     1.1/s            0.03
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        171.50M     7.2/s
Flushes        26.63M     1.1/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits            2808     0.0/s
Current             0
Time acquiring
  Total        127065 ms
  Average          45 ms
  Max           31338 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        26.36M     1.1/s
  Writes       40.04M     1.7/s
  fsync        13.50M     0.6/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     384.28k     0.0/s
  Read         35.22M     1.5/s
  Written      26.63M     1.1/s

Rows
  Deleted       4.16M     0.2/s
  Inserted      5.57M     0.2/s
  Read         88.72G    3.7k/s
  Updated       8.39M     0.4/s