thirsday 21 septembre 2023   -   23 : 15 : 30  
lang fr


Mysql status

MySQL 10.3.39-MariaDB-0  uptime 20 0:17:21      Thu Sep 21 23:10:01 2023

__ Key _________________________________________________________________
Buffer used     7.27M of  32.00M  %Used:  22.73
  Current       8.77M            %Usage:  27.41
Write ratio     1.000
Read ratio      0.000

__ Questions ___________________________________________________________
Total          42.99M    24.9/s
  DMS          40.47M    23.4/s  %Total:  94.13
  Com_          3.00M     1.7/s            6.97
  -Unknown      2.80M     1.6/s            6.51
  QC Hits       1.91M     1.1/s            4.44
  COM_QUIT    413.24k     0.2/s            0.96
Slow               86     0.0/s            0.00  %DMS:   0.00
DMS            40.47M    23.4/s           94.13
  INSERT       36.88M    21.3/s           85.77         91.12
  SELECT        3.26M     1.9/s            7.58          8.05
  UPDATE      330.58k     0.2/s            0.77          0.82
  DELETE        5.10k     0.0/s            0.01          0.01
  REPLACE           4     0.0/s            0.00          0.00
Com_            3.00M     1.7/s            6.97
  set_option    1.09M     0.6/s            2.54
  change_db   583.21k     0.3/s            1.36
  stmt_execut 334.99k     0.2/s            0.78

__ SELECT and Sort _____________________________________________________
Scan          879.70k     0.5/s %SELECT:  27.01
Range          24.30k     0.0/s            0.75
Full join         200     0.0/s            0.01
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     126.61k     0.1/s
Sort range    126.66k     0.1/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage    1.76M of  64.00M  %Used:   2.75
Block Fragmnt   0.06%
Hits            1.91M     1.1/s
Inserts       475.96k     0.3/s
Insrt:Prune 475.96k:1     0.3/s
Hit:Insert     4.01:1

__ Table Locks _________________________________________________________
Waited              0       0/s  %Total:   0.00
Immediate      38.05M    22.0/s

__ Tables ______________________________________________________________
Open              117 of         %Cache: 11700.
Opened        348.78k     0.2/s

__ Connections _________________________________________________________
Max used           54 of  100      %Max:  54.00
Total         413.27k     0.2/s

__ Created Temp ________________________________________________________
Disk table    470.37k     0.3/s
Table         764.11k     0.4/s
File                5     0.0/s

__ Threads _____________________________________________________________
Running             6 of    2
Cached             24 of   64      %Hit:  99.96
Created           157     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients            61     0.0/s
Connects       23.68k     0.0/s

__ Bytes _______________________________________________________________
Sent          161.16G   93.2k/s
Received       48.60G   28.1k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         107.44M of 128.00M  %Used:  83.94
Read ratio      0.000
Pages
  Free          1.32k            %Total:  16.06
  Data          6.19k                     75.59 %Drty:   0.00
  Misc            684                      8.35
  Latched                                  0.00
Reads         177.86M   102.9/s
  From file     5.05k     0.0/s            0.00
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          9.94M     5.7/s
Flushes         1.14M     0.7/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits               7     0.0/s
Current             0
Time acquiring
  Total            98 ms
  Average          14 ms
  Max              31 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         5.50k     0.0/s
  Writes        2.10M     1.2/s
  fsync         1.29M     0.7/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created         759     0.0/s
  Read          5.43k     0.0/s
  Written       1.14M     0.7/s

Rows
  Deleted      74.28k     0.0/s
  Inserted     81.13k     0.0/s
  Read        125.12M    72.4/s
  Updated       1.08M     0.6/s

connected from address ec2-34-204-172-188.compute-1.amazonaws.com (34.204.172.188:61526)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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