dimanche 24 septembre 2017   -   21 : 19 : 49  
lang en


Mysql status

MySQL 5.5.57-0+deb7u1-l  uptime 4 9:50:44       Sun Sep 24 21:10:02 2017

__ Key _________________________________________________________________
Buffer used    33.28M of 128.00M  %Used:  26.00
  Current      45.47M            %Usage:  35.52
Write ratio     0.422
Read ratio      0.001

__ Questions ___________________________________________________________
Total          13.43M    35.2/s
  DMS           9.73M    25.5/s  %Total:  72.46
  Com_          4.62M    12.1/s           34.41
  -Unknown      4.10M    10.7/s           30.51
  QC Hits       2.99M     7.9/s           22.31
  COM_QUIT    178.82k     0.5/s            1.33
Slow                7     0.0/s            0.00  %DMS:   0.00
DMS             9.73M    25.5/s           72.46
  INSERT        5.62M    14.7/s           41.83         57.73
  SELECT        3.43M     9.0/s           25.56         35.27
  UPDATE      539.09k     1.4/s            4.02          5.54
  DELETE      110.57k     0.3/s            0.82          1.14
  REPLACE      31.00k     0.1/s            0.23          0.32
Com_            4.62M    12.1/s           34.41
  admin_comma   4.10M    10.7/s           30.50
  set_option  281.13k     0.7/s            2.09
  change_db   235.31k     0.6/s            1.75

__ SELECT and Sort _____________________________________________________
Scan          244.25k     0.6/s %SELECT:   7.12
Range         195.98k     0.5/s            5.71
Full join       1.64k     0.0/s            0.05
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan      96.65k     0.3/s
Sort range    226.41k     0.6/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   49.95M of  64.00M  %Used:  78.05
Block Fragmnt  13.98%
Hits            2.99M     7.9/s
Inserts         3.30M     8.7/s
Insrt:Prune    4.33:1     6.7/s
Hit:Insert     0.91:1

__ Table Locks _________________________________________________________
Waited            238     0.0/s  %Total:   0.00
Immediate      10.02M    26.3/s

__ Tables ______________________________________________________________
Open            1.01k of         %Cache: 100600
Opened         21.37k     0.1/s

__ Connections _________________________________________________________
Max used           17 of  200      %Max:   8.50
Total         178.83k     0.5/s

__ Created Temp ________________________________________________________
Disk table     15.64k     0.0/s
Table          61.80k     0.2/s
File                8     0.0/s

__ Threads _____________________________________________________________
Running             1 of    3
Cached             14 of   64      %Hit:  99.99
Created            17     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients             1     0.0/s
Connects           25     0.0/s

__ Bytes _______________________________________________________________
Sent           17.09G   44.8k/s
Received        3.34G    8.8k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          81.83M of 127.98M  %Used:  63.94
Read ratio      0.000
Pages
  Free          2.95k            %Total:  36.06
  Data          5.19k                     63.37 %Drty:   0.00
  Misc             46                      0.56
  Latched                                  0.00
Reads          13.14M    34.5/s
  From file     4.41k     0.0/s            0.03
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          2.91M     7.6/s
Flushes         1.05M     2.8/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits               0       0/s
Current             0
Time acquiring
  Total             0 ms
  Average           0 ms
  Max               0 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         4.42k     0.0/s
  Writes        1.39M     3.7/s
  fsync       383.75k     1.0/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created         781     0.0/s
  Read          4.41k     0.0/s
  Written       1.05M     2.8/s

Rows
  Deleted      18.38k     0.0/s
  Inserted     16.43k     0.0/s
  Read          3.36M     8.8/s
  Updated     243.06k     0.6/s

connected from address ec2-54-92-158-65.compute-1.amazonaws.com (54.92.158.65:53067)
using CCBot/2.0 (http://commoncrawl.org/faq/)

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