dimanche 18 fevrier 2018   -   09 : 18 : 17  
lang en


Mysql status

MySQL 5.5.59-0+deb7u1-l  uptime 21 21:31:16     Sun Feb 18 09:10:01 2018

__ Key _________________________________________________________________
Buffer used    37.79M of 128.00M  %Used:  29.52
  Current      50.70M            %Usage:  39.61
Write ratio     0.653
Read ratio      0.005

__ Questions ___________________________________________________________
Total          42.53M    22.5/s
  QC Hits      25.14M    13.3/s  %Total:  59.12
  DMS          12.88M     6.8/s           30.30
  Com_          4.88M     2.6/s           11.46
  -Unknown      1.33M     0.7/s            3.13
  COM_QUIT    957.63k     0.5/s            2.25
Slow               29     0.0/s            0.00  %DMS:   0.00
DMS            12.88M     6.8/s           30.30
  SELECT        8.56M     4.5/s           20.12         66.42
  UPDATE        2.41M     1.3/s            5.66         18.68
  DELETE      816.00k     0.4/s            1.92          6.33
  INSERT      801.38k     0.4/s            1.88          6.22
  REPLACE     301.46k     0.2/s            0.71          2.34
Com_            4.88M     2.6/s           11.46
  change_db     1.78M     0.9/s            4.18
  set_option    1.70M     0.9/s            4.01
  admin_comma   1.33M     0.7/s            3.13

__ SELECT and Sort _____________________________________________________
Scan            1.06M     0.6/s %SELECT:  12.39
Range           1.63M     0.9/s           19.00
Full join       6.51k     0.0/s            0.08
Range check         0       0/s            0.00
Full rng join       7     0.0/s            0.00
Sort scan     547.75k     0.3/s
Sort range      1.51M     0.8/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   51.87M of  64.00M  %Used:  81.04
Block Fragmnt  12.99%
Hits           25.14M    13.3/s
Inserts         7.85M     4.1/s
Insrt:Prune    2.16:1     2.2/s
Hit:Insert     3.20:1

__ Table Locks _________________________________________________________
Waited          1.66k     0.0/s  %Total:   0.01
Immediate      15.10M     8.0/s

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

__ Connections _________________________________________________________
Max used           23 of  200      %Max:  11.50
Total         957.64k     0.5/s

__ Created Temp ________________________________________________________
Disk table     80.66k     0.0/s
Table         281.86k     0.1/s
File               11     0.0/s

__ Threads _____________________________________________________________
Running             1 of    1
Cached             22 of   64      %Hit:    100
Created            23     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients            22     0.0/s
Connects          145     0.0/s

__ Bytes _______________________________________________________________
Sent          107.24G   56.7k/s
Received        8.29G    4.4k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.70M of 127.98M  %Used:  99.78
Read ratio      0.000
Pages
  Free             18            %Total:   0.22
  Data          8.13k                     99.27 %Drty:   0.00
  Misc             42                      0.51
  Latched                                  0.00
Reads          50.45M    26.7/s
  From file     3.60k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          4.16M     2.2/s
Flushes       952.21k     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.92k     0.0/s
  Writes        1.39M     0.7/s
  fsync       466.74k     0.2/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       8.18k     0.0/s
  Read          3.91k     0.0/s
  Written     952.21k     0.5/s

Rows
  Deleted     142.04k     0.1/s
  Inserted    151.51k     0.1/s
  Read         27.40M    14.5/s
  Updated     221.45k     0.1/s

connected from address ec2-54-82-78-213.compute-1.amazonaws.com (54.82.78.213:37535)
using CCBot/2.0 (http://commoncrawl.org/faq/)

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