samedi 27 novembre 2021   -   16 : 36 : 12  
lang en


Mysql status

MySQL 10.1.48-MariaDB-0  uptime 26 18:0:8       Sat Nov 27 16:30:02 2021

__ Key _________________________________________________________________
Buffer used     7.21M of 128.00M  %Used:   5.64
  Current      26.25M            %Usage:  20.51
Write ratio     0.564
Read ratio      0.021

__ Questions ___________________________________________________________
Total          17.52M     7.6/s
  DMS          12.58M     5.4/s  %Total:  71.80
  -Unknown      6.45M     2.8/s           36.80
  QC Hits       6.35M     2.7/s           36.25
  Com_          3.92M     1.7/s           22.38
  COM_QUIT      1.12M     0.5/s            6.38
Slow            1.31k     0.0/s            0.01  %DMS:   0.01
DMS            12.58M     5.4/s           71.80
  SELECT       10.86M     4.7/s           62.01         86.37
  UPDATE        1.09M     0.5/s            6.24          8.70
  INSERT      408.65k     0.2/s            2.33          3.25
  DELETE      208.85k     0.1/s            1.19          1.66
  REPLACE       3.87k     0.0/s            0.02          0.03
Com_            3.92M     1.7/s           22.38
  set_option    1.82M     0.8/s           10.41
  change_db     1.41M     0.6/s            8.06
  show_fields 278.48k     0.1/s            1.59

__ SELECT and Sort _____________________________________________________
Scan            1.70M     0.7/s %SELECT:  15.61
Range         497.75k     0.2/s            4.58
Full join       9.17k     0.0/s            0.08
Range check         0       0/s            0.00
Full rng join      12     0.0/s            0.00
Sort scan     348.18k     0.2/s
Sort range     65.00k     0.0/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   35.92M of  64.00M  %Used:  56.12
Block Fragmnt   3.12%
Hits            6.35M     2.7/s
Inserts         3.22M     1.4/s
Insrt:Prune  248.60:1     1.4/s
Hit:Insert     1.97:1

__ Table Locks _________________________________________________________
Waited            961     0.0/s  %Total:   0.01
Immediate       8.30M     3.6/s

__ Tables ______________________________________________________________
Open              223 of         %Cache: 22300.
Opened        593.63k     0.3/s

__ Connections _________________________________________________________
Max used           43 of  200      %Max:  21.50
Total           1.12M     0.5/s

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

__ Threads _____________________________________________________________
Running             1 of    3
Cached             40 of   64      %Hit:    100
Created            43     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients             5     0.0/s
Connects        4.97k     0.0/s

__ Bytes _______________________________________________________________
Sent          162.35G   70.2k/s
Received        3.39G    1.5k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          62.56M of 127.98M  %Used:  48.88
Read ratio      0.000
Pages
  Free          4.19k            %Total:  51.12
  Data          3.98k                     48.60 %Drty:   0.00
  Misc             23                      0.28
  Latched                                  0.00
Reads         845.80M   366.0/s
  From file     3.53k     0.0/s            0.00
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes         29.47k     0.0/s
Flushes        12.33k     0.0/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         4.01k     0.0/s
  Writes       19.57k     0.0/s
  fsync         8.66k     0.0/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created          91     0.0/s
  Read          3.89k     0.0/s
  Written      12.33k     0.0/s

Rows
  Deleted           0       0/s
  Inserted        440     0.0/s
  Read         50.87M    22.0/s
  Updated       3.06k     0.0/s

connected from address ec2-34-228-229-51.compute-1.amazonaws.com (34.228.229.51:30482)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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