tuesday 20 february 2018   -   16 : 32 : 12  
lang fr


Mysql status

MySQL 5.5.59-0+deb7u1-l  uptime 24 4:51:16      Tue Feb 20 16:30:01 2018

__ Key _________________________________________________________________
Buffer used    37.79M of 128.00M  %Used:  29.52
  Current      52.47M            %Usage:  40.99
Write ratio     0.657
Read ratio      0.005

__ Questions ___________________________________________________________
Total          46.04M    22.0/s
  QC Hits      27.11M    13.0/s  %Total:  58.89
  DMS          14.00M     6.7/s           30.41
  Com_          5.26M     2.5/s           11.41
  -Unknown      1.38M     0.7/s            2.99
  COM_QUIT      1.05M     0.5/s            2.27
Slow               32     0.0/s            0.00  %DMS:   0.00
DMS            14.00M     6.7/s           30.41
  SELECT        9.28M     4.4/s           20.16         66.28
  UPDATE        2.61M     1.2/s            5.68         18.66
  INSERT      889.68k     0.4/s            1.93          6.35
  DELETE      886.93k     0.4/s            1.93          6.33
  REPLACE     331.10k     0.2/s            0.72          2.36
Com_            5.26M     2.5/s           11.41
  change_db     1.95M     0.9/s            4.23
  set_option    1.86M     0.9/s            4.04
  admin_comma   1.37M     0.7/s            2.99

__ SELECT and Sort _____________________________________________________
Scan            1.17M     0.6/s %SELECT:  12.60
Range           1.78M     0.9/s           19.19
Full join       7.54k     0.0/s            0.08
Range check         0       0/s            0.00
Full rng join       7     0.0/s            0.00
Sort scan     618.49k     0.3/s
Sort range      1.66M     0.8/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   52.44M of  64.00M  %Used:  81.93
Block Fragmnt  14.29%
Hits           27.11M    13.0/s
Inserts         8.50M     4.1/s
Insrt:Prune    2.15:1     2.2/s
Hit:Insert     3.19:1

__ Table Locks _________________________________________________________
Waited          1.78k     0.0/s  %Total:   0.01
Immediate      16.40M     7.8/s

__ Tables ______________________________________________________________
Open            1.02k of         %Cache: 102300
Opened         34.30k     0.0/s

__ Connections _________________________________________________________
Max used           23 of  200      %Max:  11.50
Total           1.05M     0.5/s

__ Created Temp ________________________________________________________
Disk table     89.65k     0.0/s
Table         315.52k     0.2/s
File               11     0.0/s

__ Threads _____________________________________________________________
Running             5 of    8
Cached             15 of   64      %Hit:    100
Created            23     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients            23     0.0/s
Connects          159     0.0/s

__ Bytes _______________________________________________________________
Sent          115.58G   55.3k/s
Received        9.00G    4.3k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.97M of 127.98M  %Used:  99.99
Read ratio      0.000
Pages
  Free              1            %Total:   0.01
  Data          8.15k                     99.50 %Drty:   0.04
  Misc             40                      0.49
  Latched                                  0.00
Reads          56.61M    27.1/s
  From file     3.62k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          4.46M     2.1/s
Flushes         1.03M     0.5/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         3.95k     0.0/s
  Writes        1.50M     0.7/s
  fsync       503.11k     0.2/s
  Pending
    Reads           0
    Writes          0
    fysnc           1

Pages
  Created       8.32k     0.0/s
  Read          3.94k     0.0/s
  Written       1.03M     0.5/s

Rows
  Deleted     152.63k     0.1/s
  Inserted    159.75k     0.1/s
  Read         31.30M    15.0/s
  Updated     241.51k     0.1/s

connected from address ec2-54-226-55-151.compute-1.amazonaws.com (54.226.55.151:43520)
using CCBot/2.0 (http://commoncrawl.org/faq/)

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