MySQL 10.0.17-MariaDB-1  uptime 1 0:59:28       Thu Mar 26 13:25:53 2015

__ Key _________________________________________________________________
Buffer used    47.00k of 128.00M  %Used:   0.04
  Current      23.39M            %Usage:  18.28
Write hit      14.88%
Read hit      100.00%

__ Questions ___________________________________________________________
Total         204.50M    2.3k/s
  DMS         145.95M    1.6k/s  %Total:  71.37
  Com_         35.21M   391.3/s           17.22
  COM_QUIT     24.58M   273.2/s           12.02
  -Unknown      1.87M    20.8/s            0.92
  QC Hits     638.12k     7.1/s            0.31
Slow 10 s          25     0.0/s            0.00  %DMS:   0.00  Log:
DMS           145.95M    1.6k/s           71.37
  SELECT      114.30M    1.3k/s           55.89         78.31
  UPDATE       20.38M   226.6/s            9.97         13.97
  INSERT       11.10M   123.4/s            5.43          7.61
  DELETE      166.11k     1.8/s            0.08          0.11
  REPLACE           0       0/s            0.00          0.00
Com_           35.21M   391.3/s           17.22
  set_option   24.58M   273.3/s           12.02
  call_proced  10.60M   117.8/s            5.18
  begin         6.74k     0.1/s            0.00

__ SELECT and Sort _____________________________________________________
Scan            1.29M    14.3/s %SELECT:   1.13
Range          24.30M   270.1/s           21.26
Full join          52     0.0/s            0.00
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan      11.46M   127.4/s
Sort range     11.86M   131.8/s
Sort mrg pass     469     0.0/s

__ Query Cache _________________________________________________________
Memory usage  823.41k of 128.00M  %Used:   0.63
Block Fragmnt  15.04%
Hits          638.12k     7.1/s
Inserts        35.26M   391.9/s
Insrt:Prune  35.26M:1   391.9/s
Hit:Insert     0.02:1

__ Table Locks _________________________________________________________
Waited              0       0/s  %Total:   0.00
Immediate     248.51M    2.8k/s

__ Tables ______________________________________________________________
Open              611 of 2048    %Cache:  29.83
Opened            549     0.0/s

__ Connections _________________________________________________________
Max used          116 of  200      %Max:  58.00
Total          24.58M   273.3/s

__ Created Temp ________________________________________________________
Disk table         44     0.0/s
Table          11.49M   127.7/s    Size:  64.0M
File              617     0.0/s

__ Threads _____________________________________________________________
Running            39 of   58
Cached             60 of  128      %Hit:    100
Created           118     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients        16.39k     0.2/s
Connects            0       0/s

__ Bytes _______________________________________________________________
Sent           40.71G  452.5k/s
Received       48.24G  536.2k/s

__ InnoDB Buffer Pool __________________________________________________
Usage           3.87G of   4.00G  %Used:  96.87
Read hit      100.00%
Pages
  Free          8.19k            %Total:   3.13
  Data        232.84k                     88.82 %Drty:   1.43
  Misc          21105                      8.05
  Latched           0                      0.00
Reads          99.80G    1.1M/s
  From file   205.98k     2.3/s            0.00
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes        319.12M    3.5k/s
Flushes         6.48M    72.0/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits           45731     0.5/s
Current             9
Time acquiring
  Total       1650246 ms
  Average          36 ms
  Max            2785 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads       405.30k     4.5/s
  Writes        6.88M    76.5/s
  fsync       768.54k     8.5/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     138.63k     1.5/s
  Read        405.23k     4.5/s
  Written       6.48M    72.0/s

Rows
  Deleted       6.98M    77.6/s
  Inserted     10.81M   120.2/s
  Read         54.90G  610.2k/s
  Updated      47.15M   524.1/s