sunday 19 may 2019   -   10 : 55 : 52  
lang fr


Mysql status

MySQL 5.5.60-0+deb7u1-l  uptime 20 15:16:0      Sun May 19 10:50:01 2019

__ Key _________________________________________________________________
Buffer used    26.16M of 128.00M  %Used:  20.43
  Current      31.59M            %Usage:  24.68
Write ratio     0.525
Read ratio      0.005

__ Questions ___________________________________________________________
Total          21.63M    12.1/s
  QC Hits       9.06M     5.1/s  %Total:  41.86
  DMS           7.34M     4.1/s           33.92
  Com_          4.83M     2.7/s           22.31
  COM_QUIT    794.43k     0.4/s            3.67
  -Unknown    381.97k     0.2/s            1.77
Slow            1.21k     0.0/s            0.01  %DMS:   0.02
DMS             7.34M     4.1/s           33.92
  SELECT        5.36M     3.0/s           24.78         73.05
  UPDATE        1.14M     0.6/s            5.29         15.60
  INSERT      445.94k     0.3/s            2.06          6.08
  DELETE      242.46k     0.1/s            1.12          3.30
  REPLACE     144.14k     0.1/s            0.67          1.96
Com_            4.83M     2.7/s           22.31
  set_option    2.24M     1.3/s           10.35
  change_db     1.27M     0.7/s            5.87
  admin_comma 380.26k     0.2/s            1.76

__ SELECT and Sort _____________________________________________________
Scan            1.52M     0.9/s %SELECT:  28.34
Range           1.14M     0.6/s           21.32
Full join       7.65k     0.0/s            0.14
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     590.44k     0.3/s
Sort range    419.58k     0.2/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   50.98M of  64.00M  %Used:  79.66
Block Fragmnt  17.66%
Hits            9.06M     5.1/s
Inserts         4.36M     2.4/s
Insrt:Prune    2.30:1     1.4/s
Hit:Insert     2.08:1

__ Table Locks _________________________________________________________
Waited          2.31k     0.0/s  %Total:   0.03
Immediate       7.41M     4.2/s

__ Tables ______________________________________________________________
Open            1.02k of         %Cache: 102300
Opened        419.76k     0.2/s

__ Connections _________________________________________________________
Max used           48 of  200      %Max:  24.00
Total         794.70k     0.4/s

__ Created Temp ________________________________________________________
Disk table    476.35k     0.3/s
Table         964.98k     0.5/s
File               10     0.0/s

__ Threads _____________________________________________________________
Running             1 of    4
Cached             44 of   64      %Hit:  99.99
Created            48     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients           530     0.0/s
Connects          180     0.0/s

__ Bytes _______________________________________________________________
Sent          144.00G   80.8k/s
Received        3.34G    1.9k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.95M of 128.00M  %Used:  99.96
Read ratio      0.000
Pages
  Free              3            %Total:   0.04
  Data          8.11k                     98.99 %Drty:   0.00
  Misc             80                      0.98
  Latched                                  0.00
Reads          54.02M    30.3/s
  From file     9.97k     0.0/s            0.02
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          2.87M     1.6/s
Flushes       641.48k     0.4/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits               6     0.0/s
Current             0
Time acquiring
  Total            63 ms
  Average          10 ms
  Max              63 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        10.16k     0.0/s
  Writes      910.04k     0.5/s
  fsync       293.86k     0.2/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created      10.11k     0.0/s
  Read         10.15k     0.0/s
  Written     641.48k     0.4/s

Rows
  Deleted     107.70k     0.1/s
  Inserted    131.58k     0.1/s
  Read         36.66M    20.6/s
  Updated      98.33k     0.1/s

connected from address ec2-35-175-248-25.compute-1.amazonaws.com (35.175.248.25:40613)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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