monday 03 aout 2020   -   10 : 36 : 56  
lang fr


Mysql status

MySQL 5.5.62-0+deb8u1-l  uptime 38 17:21:53     Mon Aug  3 10:30:02 2020

__ Key _________________________________________________________________
Buffer used    18.40M of 128.00M  %Used:  14.37
  Current      26.06M            %Usage:  20.36
Write ratio     0.302
Read ratio      0.011

__ Questions ___________________________________________________________
Total          60.59M    18.1/s
  QC Hits      29.17M     8.7/s  %Total:  48.14
  DMS          18.22M     5.4/s           30.08
  Com_         11.02M     3.3/s           18.19
  COM_QUIT      2.20M     0.7/s            3.64
  -Unknown     28.59k     0.0/s            0.05
Slow            6.01k     0.0/s            0.01  %DMS:   0.03
DMS            18.22M     5.4/s           30.08
  SELECT       12.34M     3.7/s           20.37         67.74
  UPDATE        3.34M     1.0/s            5.52         18.34
  DELETE        1.16M     0.3/s            1.92          6.37
  INSERT      840.66k     0.3/s            1.39          4.61
  REPLACE     535.33k     0.2/s            0.88          2.94
Com_           11.02M     3.3/s           18.19
  set_option    4.94M     1.5/s            8.16
  change_db     4.28M     1.3/s            7.07
  show_fields 402.08k     0.1/s            0.66

__ SELECT and Sort _____________________________________________________
Scan            2.58M     0.8/s %SELECT:  20.92
Range           1.89M     0.6/s           15.31
Full join      18.18k     0.0/s            0.15
Range check         0       0/s            0.00
Full rng join      40     0.0/s            0.00
Sort scan     696.12k     0.2/s
Sort range      1.60M     0.5/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   17.32k of  64.00M  %Used:   0.03
Block Fragmnt 100.00%
Hits           29.17M     8.7/s
Inserts         9.79M     2.9/s
Insrt:Prune    9.56:1     2.6/s
Hit:Insert     2.98:1

__ Table Locks _________________________________________________________
Waited          4.06k     0.0/s  %Total:   0.02
Immediate      19.92M     6.0/s

__ Tables ______________________________________________________________
Open              469 of         %Cache: 46900.
Opened          1.01M     0.3/s

__ Connections _________________________________________________________
Max used           55 of  200      %Max:  27.50
Total           2.20M     0.7/s

__ Created Temp ________________________________________________________
Disk table      1.15M     0.3/s
Table           1.85M     0.6/s
File               15     0.0/s

__ Threads _____________________________________________________________
Running             3 of    7
Cached             48 of   64      %Hit:    100
Created            55     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients            32     0.0/s
Connects       31.84k     0.0/s

__ Bytes _______________________________________________________________
Sent          291.18G   87.0k/s
Received        9.60G    2.9k/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.12k                     99.16 %Drty:   0.00
  Misc             68                      0.83
  Latched                                  0.00
Reads         172.73M    51.6/s
  From file    13.54k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          6.36M     1.9/s
Flushes         1.26M     0.4/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits              45     0.0/s
Current             0
Time acquiring
  Total         11182 ms
  Average         248 ms
  Max            8002 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        14.00k     0.0/s
  Writes        1.78M     0.5/s
  fsync       592.46k     0.2/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created      19.47k     0.0/s
  Read         13.99k     0.0/s
  Written       1.26M     0.4/s

Rows
  Deleted     259.32k     0.1/s
  Inserted    269.50k     0.1/s
  Read        111.64M    33.4/s
  Updated     158.69k     0.0/s

connected from address ec2-3-215-174-30.compute-1.amazonaws.com (3.215.174.30:54602)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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