MySQL 5.0.51a-log        uptime 3 3:27:50       Sun Oct 23 12:04:04 2011

__ Key _________________________________________________________________
Buffer used    10.00k of   8.00M  %Used:   0.12
  Current     953.99k            %Usage:  11.65
Write hit       0.00%
Read hit       73.68%

__ Questions ___________________________________________________________
Total           6.85M    25.2/s
  QC Hits       6.32M    23.3/s  %Total:  92.27
  Com_        823.18k     3.0/s           12.01
  -Unknown    734.29k     2.7/s           10.72
  DMS         439.47k     1.6/s            6.41
  COM_QUIT      1.61k     0.0/s            0.02
Slow (6)        1.66k     0.0/s            0.02  %DMS:   0.38  Log:  ON
DMS           439.47k     1.6/s            6.41
  SELECT      417.83k     1.5/s            6.10         95.08
  UPDATE        9.18k     0.0/s            0.13          2.09
  INSERT        7.26k     0.0/s            0.11          1.65
  DELETE        5.20k     0.0/s            0.08          1.18
  REPLACE           0       0/s            0.00          0.00
Com_          823.18k     3.0/s           12.01
  show_status 734.23k     2.7/s           10.72
  begin        40.88k     0.2/s            0.60
  commit       40.81k     0.2/s            0.60

__ SELECT and Sort _____________________________________________________
Scan           81.29k     0.3/s %SELECT:  19.46
Range          34.51k     0.1/s            8.26
Full join           0       0/s            0.00
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan      74.64k     0.3/s
Sort range    159.69k     0.6/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   24.19M of  32.00M  %Used:  75.60
Block Fragmnt  18.14%
Hits            6.32M    23.3/s
Inserts       399.86k     1.5/s
Insrt:Prune   21.29:1     1.4/s
Hit:Insert    15.81:1

__ Table Locks _________________________________________________________
Waited              0       0/s  %Total:   0.00
Immediate     626.72k     2.3/s

__ Tables ______________________________________________________________
Open              293 of  800    %Cache:  36.62
Opened            457     0.0/s

__ Connections _________________________________________________________
Max used          175 of 2000      %Max:   8.75
Total           1.73k     0.0/s

__ Created Temp ________________________________________________________
Disk table      7.90k     0.0/s
Table          62.31k     0.2/s    Size:  96.0M
File                5     0.0/s

__ Threads _____________________________________________________________
Running             1 of   60
Cached             14 of   16      %Hit:  89.86
Created           175     0.0/s
Slow                2     0.0/s

__ Aborted _____________________________________________________________
Clients           232     0.0/s
Connects           18     0.0/s

__ Bytes _______________________________________________________________
Sent          742.05M    2.7k/s
Received      791.59M    2.9k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         182.09M of 256.00M  %Used:  71.13
Read hit      100.00%
Pages
  Free          4.73k            %Total:  28.87
  Data         11.39k                     69.51 %Drty:   0.00
  Misc            266                      1.62
  Latched           0                      0.00
Reads         290.53M    1.1k/s
  From file     2.86k     0.0/s            0.00
  Ahead Rnd         3     0.0/s
  Ahead Sql        63     0.0/s
Writes          2.83M    10.4/s
Flushes        65.30k     0.2/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits              70     0.0/s
Current             0
Time acquiring
  Total         20367 ms
  Average         290 ms
  Max            2017 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         3.12k     0.0/s
  Writes       59.85k     0.2/s
  fsync        36.88k     0.1/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created       5.41k     0.0/s
  Read          5.98k     0.0/s
  Written      65.30k     0.2/s

Rows
  Deleted       5.20k     0.0/s
  Inserted    553.82k     2.0/s
  Read          1.31G    4.8k/s
  Updated       9.18k     0.0/s