mardi 30 mai 2017   -   15 : 01 : 31  
lang en


Mysql status

MySQL 5.5.55-0+deb7u1-l  uptime 22 1:1:22       Tue May 30 15:00:01 2017

__ Key _________________________________________________________________
Buffer used    50.16M of 128.00M  %Used:  39.19
  Current      62.84M            %Usage:  49.09
Write ratio     0.600
Read ratio      0.003

__ Questions ___________________________________________________________
Total          29.17M    15.3/s
  QC Hits      14.74M     7.7/s  %Total:  50.51
  DMS          11.51M     6.0/s           39.45
  Com_          5.16M     2.7/s           17.70
  -Unknown      2.97M     1.6/s           10.18
  COM_QUIT    733.53k     0.4/s            2.51
Slow              417     0.0/s            0.00  %DMS:   0.00
DMS            11.51M     6.0/s           39.45
  SELECT        8.14M     4.3/s           27.90         70.73
  UPDATE        2.39M     1.3/s            8.19         20.76
  INSERT      579.40k     0.3/s            1.99          5.03
  DELETE      345.75k     0.2/s            1.19          3.00
  REPLACE      53.72k     0.0/s            0.18          0.47
Com_            5.16M     2.7/s           17.70
  admin_comma   2.96M     1.6/s           10.16
  set_option    1.15M     0.6/s            3.93
  change_db   968.32k     0.5/s            3.32

__ SELECT and Sort _____________________________________________________
Scan          838.66k     0.4/s %SELECT:  10.30
Range         886.85k     0.5/s           10.90
Full join       8.58k     0.0/s            0.11
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     398.37k     0.2/s
Sort range    981.05k     0.5/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   53.60M of  64.00M  %Used:  83.75
Block Fragmnt  11.00%
Hits           14.74M     7.7/s
Inserts         7.76M     4.1/s
Insrt:Prune    1.93:1     2.0/s
Hit:Insert     1.90:1

__ Table Locks _________________________________________________________
Waited          1.56k     0.0/s  %Total:   0.01
Immediate      13.59M     7.1/s

__ Tables ______________________________________________________________
Open            1.02k of         %Cache: 102400
Opened         15.48k     0.0/s

__ Connections _________________________________________________________
Max used           45 of  200      %Max:  22.50
Total         734.64k     0.4/s

__ Created Temp ________________________________________________________
Disk table     79.63k     0.0/s
Table         248.01k     0.1/s
File               16     0.0/s

__ Threads _____________________________________________________________
Running             2 of    9
Cached             36 of   64      %Hit:  99.99
Created            45     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients         2.20k     0.0/s
Connects          123     0.0/s

__ Bytes _______________________________________________________________
Sent           82.98G   43.6k/s
Received        7.26G    3.8k/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.13k                     99.24 %Drty:   0.04
  Misc             61                      0.74
  Latched                                  0.00
Reads          59.08M    31.0/s
  From file     4.33k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          8.82M     4.6/s
Flushes         3.10M     1.6/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits               4     0.0/s
Current             0
Time acquiring
  Total          1658 ms
  Average         414 ms
  Max             828 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         4.47k     0.0/s
  Writes        4.35M     2.3/s
  fsync         1.39M     0.7/s
  Pending
    Reads           0
    Writes          0
    fysnc           1

Pages
  Created       6.32k     0.0/s
  Read          4.46k     0.0/s
  Written       3.10M     1.6/s

Rows
  Deleted     112.57k     0.1/s
  Inserted    124.84k     0.1/s
  Read         19.96M    10.5/s
  Updated     862.05k     0.5/s

connected from address ec2-54-81-188-230.compute-1.amazonaws.com (54.81.188.230:58101)
using CCBot/2.0 (http://commoncrawl.org/faq/)

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