wednesday 16 june 2021   -   09 : 29 : 42  
lang fr


Mysql status

MySQL 10.1.48-MariaDB-0  uptime 2 9:22:29       Wed Jun 16 09:20:01 2021

__ Key _________________________________________________________________
Buffer used     4.98M of 128.00M  %Used:   3.89
  Current      24.80M            %Usage:  19.38
Write ratio     0.576
Read ratio      0.019

__ Questions ___________________________________________________________
Total           1.52M     7.4/s
  DMS           1.06M     5.1/s  %Total:  69.63
  -Unknown    462.85k     2.2/s           30.44
  QC Hits     457.52k     2.2/s           30.09
  Com_        375.38k     1.8/s           24.69
  COM_QUIT     91.72k     0.4/s            6.03
Slow               53     0.0/s            0.00  %DMS:   0.01
DMS             1.06M     5.1/s           69.63
  SELECT      888.67k     4.3/s           58.45         83.95
  UPDATE      107.14k     0.5/s            7.05         10.12
  INSERT       40.90k     0.2/s            2.69          3.86
  DELETE       21.36k     0.1/s            1.41          2.02
  REPLACE         490     0.0/s            0.03          0.05
Com_          375.38k     1.8/s           24.69
  set_option  189.56k     0.9/s           12.47
  change_db   115.49k     0.6/s            7.60
  show_fields  31.14k     0.2/s            2.05

__ SELECT and Sort _____________________________________________________
Scan          173.22k     0.8/s %SELECT:  19.49
Range          40.17k     0.2/s            4.52
Full join       1.00k     0.0/s            0.11
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan      29.65k     0.1/s
Sort range      6.67k     0.0/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   24.03M of  64.00M  %Used:  37.55
Block Fragmnt   3.20%
Hits          457.52k     2.2/s
Inserts       285.17k     1.4/s
Insrt:Prune 285.17k:1     1.4/s
Hit:Insert     1.60:1

__ Table Locks _________________________________________________________
Waited             76     0.0/s  %Total:   0.01
Immediate     747.91k     3.6/s

__ Tables ______________________________________________________________
Open              198 of         %Cache: 19800.
Opened         71.13k     0.3/s

__ Connections _________________________________________________________
Max used           52 of  200      %Max:  26.00
Total          91.73k     0.4/s

__ Created Temp ________________________________________________________
Disk table     78.94k     0.4/s
Table         122.75k     0.6/s
File                6     0.0/s

__ Threads _____________________________________________________________
Running             1 of    1
Cached             51 of   64      %Hit:  99.94
Created            52     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients            25     0.0/s
Connects          637     0.0/s

__ Bytes _______________________________________________________________
Sent           16.39G   79.3k/s
Received      277.66M    1.3k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          76.45M of 127.98M  %Used:  59.74
Read ratio      0.000
Pages
  Free          3.30k            %Total:  40.26
  Data          4.87k                     59.42 %Drty:   0.00
  Misc             26                      0.32
  Latched                                  0.00
Reads          77.93M   377.3/s
  From file     4.40k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes            601     0.0/s
Flushes           323     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.99k     0.0/s
  Writes          591     0.0/s
  fsync           325     0.0/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created           0       0/s
  Read          4.87k     0.0/s
  Written         323     0.0/s

Rows
  Deleted           0       0/s
  Inserted         18     0.0/s
  Read          7.08M    34.3/s
  Updated          46     0.0/s

connected from address ec2-35-170-64-36.compute-1.amazonaws.com (35.170.64.36:31298)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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