thirsday 23 septembre 2021   -   22 : 03 : 04  
lang fr


Mysql status

MySQL 10.1.48-MariaDB-0  uptime 3 9:18:10       Thu Sep 23 22:00:02 2021

__ Key _________________________________________________________________
Buffer used     5.58M of 128.00M  %Used:   4.36
  Current      25.03M            %Usage:  19.55
Write ratio     0.558
Read ratio      0.024

__ Questions ___________________________________________________________
Total           1.89M     6.5/s
  DMS           1.33M     4.6/s  %Total:  70.46
  -Unknown    643.26k     2.2/s           33.98
  QC Hits     628.02k     2.1/s           33.17
  Com_        439.63k     1.5/s           23.22
  COM_QUIT    134.87k     0.5/s            7.12
Slow               54     0.0/s            0.00  %DMS:   0.00
DMS             1.33M     4.6/s           70.46
  SELECT        1.14M     3.9/s           60.39         85.71
  UPDATE      122.48k     0.4/s            6.47          9.18
  INSERT       44.79k     0.2/s            2.37          3.36
  DELETE       22.95k     0.1/s            1.21          1.72
  REPLACE         413     0.0/s            0.02          0.03
Com_          439.63k     1.5/s           23.22
  set_option  198.69k     0.7/s           10.50
  change_db   159.71k     0.5/s            8.44
  show_fields  31.27k     0.1/s            1.65

__ SELECT and Sort _____________________________________________________
Scan          186.48k     0.6/s %SELECT:  16.31
Range          47.32k     0.2/s            4.14
Full join       1.17k     0.0/s            0.10
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan      39.30k     0.1/s
Sort range      8.83k     0.0/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   33.76M of  64.00M  %Used:  52.75
Block Fragmnt   3.46%
Hits          628.02k     2.1/s
Inserts       364.90k     1.2/s
Insrt:Prune 364.90k:1     1.2/s
Hit:Insert     1.72:1

__ Table Locks _________________________________________________________
Waited            167     0.0/s  %Total:   0.02
Immediate     919.93k     3.1/s

__ Tables ______________________________________________________________
Open              200 of         %Cache: 20000.
Opened         72.32k     0.2/s

__ Connections _________________________________________________________
Max used           13 of  200      %Max:   6.50
Total         134.87k     0.5/s

__ Created Temp ________________________________________________________
Disk table     85.14k     0.3/s
Table         131.21k     0.4/s
File                6     0.0/s

__ Threads _____________________________________________________________
Running             1 of    3
Cached             10 of   64      %Hit:  99.99
Created            13     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients             0       0/s
Connects          460     0.0/s

__ Bytes _______________________________________________________________
Sent           18.61G   63.6k/s
Received      362.35M    1.2k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          55.25M of 127.98M  %Used:  43.17
Read ratio      0.000
Pages
  Free          4.66k            %Total:  56.83
  Data          3.52k                     42.91 %Drty:   0.03
  Misc             21                      0.26
  Latched                                  0.00
Reads         107.06M   365.8/s
  From file     3.17k     0.0/s            0.00
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          3.63k     0.0/s
Flushes         1.41k     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         3.62k     0.0/s
  Writes        2.23k     0.0/s
  fsync           963     0.0/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created          16     0.0/s
  Read          3.50k     0.0/s
  Written       1.41k     0.0/s

Rows
  Deleted           0       0/s
  Inserted         44     0.0/s
  Read          5.41M    18.5/s
  Updated         389     0.0/s

connected from address ec2-3-237-2-4.compute-1.amazonaws.com (3.237.2.4:24624)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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