monday 20 january 2020   -   14 : 21 : 45  
lang fr


Mysql status

MySQL 5.5.62-0+deb8u1-l  uptime 42 7:10:4       Fri Jan 10 18:50:01 2020

__ Key _________________________________________________________________
Buffer used    18.07M of 128.00M  %Used:  14.12
  Current      25.36M            %Usage:  19.81
Write ratio     0.522
Read ratio      0.008

__ Questions ___________________________________________________________
Total         101.75M    27.8/s
  QC Hits      47.91M    13.1/s  %Total:  47.09
  DMS          34.38M     9.4/s           33.79
  Com_         16.14M     4.4/s           15.86
  COM_QUIT      3.31M     0.9/s            3.26
  +Unknown      5.73k     0.0/s            0.01
Slow            8.59k     0.0/s            0.01  %DMS:   0.02
DMS            34.38M     9.4/s           33.79
  SELECT       21.38M     5.9/s           21.01         62.18
  UPDATE        8.28M     2.3/s            8.14         24.09
  DELETE        2.13M     0.6/s            2.09          6.19
  INSERT        1.49M     0.4/s            1.47          4.34
  REPLACE       1.10M     0.3/s            1.08          3.20
Com_           16.14M     4.4/s           15.86
  set_option    7.24M     2.0/s            7.11
  change_db     6.63M     1.8/s            6.52
  show_fields 429.30k     0.1/s            0.42

__ SELECT and Sort _____________________________________________________
Scan            4.75M     1.3/s %SELECT:  22.20
Range           3.69M     1.0/s           17.28
Full join      67.32k     0.0/s            0.31
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan       2.36M     0.6/s
Sort range      1.67M     0.5/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   30.75M of  64.00M  %Used:  48.04
Block Fragmnt   0.06%
Hits           47.91M    13.1/s
Inserts        16.84M     4.6/s
Insrt:Prune   10.17:1     4.2/s
Hit:Insert     2.85:1

__ Table Locks _________________________________________________________
Waited         17.73k     0.0/s  %Total:   0.05
Immediate      34.50M     9.4/s

__ Tables ______________________________________________________________
Open              330 of         %Cache: 33000.
Opened          1.09M     0.3/s

__ Connections _________________________________________________________
Max used           62 of  200      %Max:  31.00
Total           3.31M     0.9/s

__ Created Temp ________________________________________________________
Disk table      1.06M     0.3/s
Table           2.04M     0.6/s
File               13     0.0/s

__ Threads _____________________________________________________________
Running             1 of    2
Cached             60 of   64      %Hit:    100
Created            62     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients           645     0.0/s
Connects          162     0.0/s

__ Bytes _______________________________________________________________
Sent          340.45G   93.2k/s
Received       16.35G    4.5k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.95M of 127.98M  %Used:  99.98
Read ratio      0.000
Pages
  Free              2            %Total:   0.02
  Data          8.15k                     99.52 %Drty:   0.00
  Misc             37                      0.45
  Latched                                  0.00
Reads         120.53M    33.0/s
  From file    10.32k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          5.21M     1.4/s
Flushes         1.07M     0.3/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits               9     0.0/s
Current             0
Time acquiring
  Total           195 ms
  Average          21 ms
  Max             102 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        10.49k     0.0/s
  Writes        1.51M     0.4/s
  fsync       485.71k     0.1/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       8.62k     0.0/s
  Read         10.48k     0.0/s
  Written       1.07M     0.3/s

Rows
  Deleted     211.97k     0.1/s
  Inserted    216.81k     0.1/s
  Read         71.38M    19.5/s
  Updated     142.65k     0.0/s

connected from address ec2-35-172-195-82.compute-1.amazonaws.com (35.172.195.82:47095)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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