wednesday 22 novembre 2017   -   06 : 28 : 36  
lang fr


Mysql status

MySQL 5.5.58-0+deb7u1-l  uptime 12 17:38:8      Wed Nov 22 06:20:01 2017

__ Key _________________________________________________________________
Buffer used    33.00M of 128.00M  %Used:  25.78
  Current      45.83M            %Usage:  35.81
Write ratio     0.413
Read ratio      0.001

__ Questions ___________________________________________________________
Total          46.72M    42.5/s
  DMS          33.46M    30.4/s  %Total:  71.63
  Com_         12.40M    11.3/s           26.54
  QC Hits      11.41M    10.4/s           24.43
  -Unknown     11.01M    10.0/s           23.56
  COM_QUIT    450.72k     0.4/s            0.96
Slow                9     0.0/s            0.00  %DMS:   0.00
DMS            33.46M    30.4/s           71.63
  INSERT       22.08M    20.1/s           47.27         66.00
  SELECT        9.30M     8.5/s           19.92         27.81
  UPDATE        1.64M     1.5/s            3.51          4.90
  DELETE      338.87k     0.3/s            0.73          1.01
  REPLACE      92.70k     0.1/s            0.20          0.28
Com_           12.40M    11.3/s           26.54
  admin_comma  11.00M    10.0/s           23.56
  set_option  727.98k     0.7/s            1.56
  change_db   638.57k     0.6/s            1.37

__ SELECT and Sort _____________________________________________________
Scan          697.44k     0.6/s %SELECT:   7.50
Range         593.98k     0.5/s            6.38
Full join       4.38k     0.0/s            0.05
Range check         0       0/s            0.00
Full rng join       2     0.0/s            0.00
Sort scan     282.10k     0.3/s
Sort range    742.08k     0.7/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   53.00M of  64.00M  %Used:  82.82
Block Fragmnt  11.30%
Hits           11.41M    10.4/s
Inserts         9.01M     8.2/s
Insrt:Prune    5.10:1     6.6/s
Hit:Insert     1.27:1

__ Table Locks _________________________________________________________
Waited          1.00k     0.0/s  %Total:   0.00
Immediate      34.44M    31.3/s

__ Tables ______________________________________________________________
Open            1.01k of         %Cache: 100900
Opened          9.49k     0.0/s

__ Connections _________________________________________________________
Max used           51 of  200      %Max:  25.50
Total         450.73k     0.4/s

__ Created Temp ________________________________________________________
Disk table     52.43k     0.0/s
Table         189.58k     0.2/s
File                9     0.0/s

__ Threads _____________________________________________________________
Running             1 of    2
Cached             49 of   64      %Hit:  99.99
Created            51     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients            13     0.0/s
Connects           56     0.0/s

__ Bytes _______________________________________________________________
Sent           60.86G   55.3k/s
Received       12.43G   11.3k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         104.05M of 127.98M  %Used:  81.30
Read ratio      0.000
Pages
  Free          1.53k            %Total:  18.70
  Data          6.60k                     80.53 %Drty:   0.36
  Misc             63                      0.77
  Latched                                  0.00
Reads          45.95M    41.8/s
  From file     2.46k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          9.66M     8.8/s
Flushes         3.33M     3.0/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits               7     0.0/s
Current             0
Time acquiring
  Total            17 ms
  Average           2 ms
  Max              16 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         2.90k     0.0/s
  Writes        4.44M     4.0/s
  fsync         1.24M     1.1/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       3.84k     0.0/s
  Read          2.76k     0.0/s
  Written       3.33M     3.0/s

Rows
  Deleted      83.06k     0.1/s
  Inserted     78.57k     0.1/s
  Read         22.89M    20.8/s
  Updated     750.07k     0.7/s

connected from address ec2-54-224-18-114.compute-1.amazonaws.com (54.224.18.114:40422)
using CCBot/2.0 (http://commoncrawl.org/faq/)

Ironie.org : www | ftp | news |  heberg  | forums | listes | miroirs | musique | europe | france | petitions | support | webmail |