thirsday 15 april 2021   -   12 : 03 : 49  
lang fr


Mysql status

MySQL 10.1.48-MariaDB-0  uptime 10 13:53:36     Thu Apr 15 12:00:02 2021

__ Key _________________________________________________________________
Buffer used     6.03M of 128.00M  %Used:   4.71
  Current      25.13M            %Usage:  19.63
Write ratio     0.542
Read ratio      0.022

__ Questions ___________________________________________________________
Total           6.40M     7.0/s
  DMS           4.52M     4.9/s  %Total:  70.61
  -Unknown      2.18M     2.4/s           34.02
  QC Hits       2.15M     2.4/s           33.55
  Com_          1.51M     1.6/s           23.54
  COM_QUIT    404.57k     0.4/s            6.32
Slow              133     0.0/s            0.00  %DMS:   0.00
DMS             4.52M     4.9/s           70.61
  SELECT        3.87M     4.2/s           60.49         85.67
  UPDATE      431.42k     0.5/s            6.74          9.54
  INSERT      137.04k     0.1/s            2.14          3.03
  DELETE       76.05k     0.1/s            1.19          1.68
  REPLACE       3.33k     0.0/s            0.05          0.07
Com_            1.51M     1.6/s           23.54
  set_option  726.28k     0.8/s           11.35
  change_db   510.04k     0.6/s            7.97
  show_fields 115.05k     0.1/s            1.80

__ SELECT and Sort _____________________________________________________
Scan          645.76k     0.7/s %SELECT:  16.67
Range         170.63k     0.2/s            4.41
Full join       4.73k     0.0/s            0.12
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     118.00k     0.1/s
Sort range     25.96k     0.0/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   32.00M of  64.00M  %Used:  50.00
Block Fragmnt   2.85%
Hits            2.15M     2.4/s
Inserts         1.21M     1.3/s
Insrt:Prune   1.21M:1     1.3/s
Hit:Insert     1.78:1

__ Table Locks _________________________________________________________
Waited            215     0.0/s  %Total:   0.01
Immediate       3.07M     3.4/s

__ Tables ______________________________________________________________
Open              212 of         %Cache: 21200.
Opened        242.79k     0.3/s

__ Connections _________________________________________________________
Max used           51 of  200      %Max:  25.50
Total         404.58k     0.4/s

__ Created Temp ________________________________________________________
Disk table    292.40k     0.3/s
Table         457.82k     0.5/s
File                6     0.0/s

__ Threads _____________________________________________________________
Running             1 of    2
Cached             50 of   64      %Hit:  99.99
Created            52     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients             0       0/s
Connects        3.47k     0.0/s

__ Bytes _______________________________________________________________
Sent           62.80G   68.7k/s
Received        1.19G    1.3k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          77.20M of 127.98M  %Used:  60.32
Read ratio      0.000
Pages
  Free          3.25k            %Total:  39.68
  Data          4.92k                     60.05 %Drty:   0.00
  Misc             22                      0.27
  Latched                                  0.00
Reads         327.61M   358.4/s
  From file     4.43k     0.0/s            0.00
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          5.60k     0.0/s
Flushes         2.19k     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         5.03k     0.0/s
  Writes        3.62k     0.0/s
  fsync         1.71k     0.0/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created           8     0.0/s
  Read          4.91k     0.0/s
  Written       2.19k     0.0/s

Rows
  Deleted           6     0.0/s
  Inserted         93     0.0/s
  Read         13.36M    14.6/s
  Updated         515     0.0/s

connected from address ec2-34-204-185-54.compute-1.amazonaws.com (34.204.185.54:28732)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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