sunday 24 octobre 2021   -   23 : 48 : 34  
lang fr


Mysql status

MySQL 10.1.48-MariaDB-0  uptime 34 10:58:10     Sun Oct 24 23:40:02 2021

__ Key _________________________________________________________________
Buffer used     6.64M of 128.00M  %Used:   5.18
  Current      25.14M            %Usage:  19.64
Write ratio     0.560
Read ratio      0.019

__ Questions ___________________________________________________________
Total          24.29M     8.2/s
  DMS          17.86M     6.0/s  %Total:  73.54
  -Unknown      9.14M     3.1/s           37.63
  QC Hits       8.87M     3.0/s           36.52
  Com_          5.24M     1.8/s           21.56
  COM_QUIT      1.46M     0.5/s            6.00
Slow            2.65k     0.0/s            0.01  %DMS:   0.01
DMS            17.86M     6.0/s           73.54
  SELECT       15.09M     5.1/s           62.12         84.47
  UPDATE        1.82M     0.6/s            7.51         10.21
  INSERT      608.81k     0.2/s            2.51          3.41
  DELETE      335.34k     0.1/s            1.38          1.88
  REPLACE       6.06k     0.0/s            0.02          0.03
Com_            5.24M     1.8/s           21.56
  set_option    2.40M     0.8/s            9.89
  change_db     1.83M     0.6/s            7.51
  show_fields 351.22k     0.1/s            1.45

__ SELECT and Sort _____________________________________________________
Scan            2.15M     0.7/s %SELECT:  14.28
Range         688.72k     0.2/s            4.56
Full join      21.43k     0.0/s            0.14
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     456.22k     0.2/s
Sort range     92.01k     0.0/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   31.82M of  64.00M  %Used:  49.72
Block Fragmnt   1.85%
Hits            8.87M     3.0/s
Inserts         4.61M     1.5/s
Insrt:Prune   4.61M:1     1.5/s
Hit:Insert     1.92:1

__ Table Locks _________________________________________________________
Waited          3.08k     0.0/s  %Total:   0.03
Immediate      12.20M     4.1/s

__ Tables ______________________________________________________________
Open              188 of         %Cache: 18800.
Opened        731.09k     0.2/s

__ Connections _________________________________________________________
Max used           53 of  200      %Max:  26.50
Total           1.46M     0.5/s

__ Created Temp ________________________________________________________
Disk table    968.86k     0.3/s
Table           1.49M     0.5/s
File                6     0.0/s

__ Threads _____________________________________________________________
Running             2 of    3
Cached             50 of   64      %Hit:    100
Created            53     0.0/s
Slow                1     0.0/s

__ Aborted _____________________________________________________________
Clients             9     0.0/s
Connects        5.66k     0.0/s

__ Bytes _______________________________________________________________
Sent          210.60G   70.7k/s
Received        4.95G    1.7k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          57.30M of 127.98M  %Used:  44.77
Read ratio      0.000
Pages
  Free          4.52k            %Total:  55.23
  Data          3.65k                     44.50 %Drty:   0.00
  Misc             22                      0.27
  Latched                                  0.00
Reads           1.10G   369.0/s
  From file     3.18k     0.0/s            0.00
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes         44.16k     0.0/s
Flushes        18.44k     0.0/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits               1     0.0/s
Current             0
Time acquiring
  Total           435 ms
  Average         435 ms
  Max             435 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         3.64k     0.0/s
  Writes       29.09k     0.0/s
  fsync        12.81k     0.0/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created         131     0.0/s
  Read          3.51k     0.0/s
  Written      18.44k     0.0/s

Rows
  Deleted          15     0.0/s
  Inserted        579     0.0/s
  Read         70.47M    23.7/s
  Updated       4.64k     0.0/s

connected from address ec2-35-175-107-77.compute-1.amazonaws.com (35.175.107.77:24722)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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