friday 09 june 2023   -   19 : 01 : 49  
lang fr


Mysql status

MySQL 10.3.39-MariaDB-0  uptime 4 5:47:11       Fri Jun  9 19:00:01 2023

__ Key _________________________________________________________________
Buffer used     6.30M of  32.00M  %Used:  19.69
  Current       5.89M            %Usage:  18.40
Write ratio     1.000
Read ratio      0.000

__ Questions ___________________________________________________________
Total           8.89M    24.3/s
  DMS           8.43M    23.0/s  %Total:  94.83
  Com_        593.92k     1.6/s            6.68
  -Unknown    467.51k     1.3/s            5.26
  QC Hits     268.13k     0.7/s            3.02
  COM_QUIT     64.77k     0.2/s            0.73
Slow               17     0.0/s            0.00  %DMS:   0.00
DMS             8.43M    23.0/s           94.83
  INSERT        7.83M    21.4/s           88.08         92.88
  SELECT      527.31k     1.4/s            5.93          6.25
  UPDATE       71.90k     0.2/s            0.81          0.85
  DELETE        1.08k     0.0/s            0.01          0.01
  REPLACE           2     0.0/s            0.00          0.00
Com_          593.92k     1.6/s            6.68
  set_option  217.18k     0.6/s            2.44
  change_db    90.18k     0.2/s            1.01
  stmt_execut  76.95k     0.2/s            0.87

__ SELECT and Sort _____________________________________________________
Scan          176.46k     0.5/s %SELECT:  33.46
Range           5.31k     0.0/s            1.01
Full join          18     0.0/s            0.00
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan      24.11k     0.1/s
Sort range     12.74k     0.0/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage    2.99M of  64.00M  %Used:   4.68
Block Fragmnt   4.02%
Hits          268.13k     0.7/s
Inserts        79.25k     0.2/s
Insrt:Prune  79.25k:1     0.2/s
Hit:Insert     3.38:1

__ Table Locks _________________________________________________________
Waited              0       0/s  %Total:   0.00
Immediate       8.03M    21.9/s

__ Tables ______________________________________________________________
Open              104 of         %Cache: 10400.
Opened         76.51k     0.2/s

__ Connections _________________________________________________________
Max used           12 of  100      %Max:  12.00
Total          64.78k     0.2/s

__ Created Temp ________________________________________________________
Disk table     93.40k     0.3/s
Table         152.36k     0.4/s
File                5     0.0/s

__ Threads _____________________________________________________________
Running             8 of    7
Cached              3 of   64      %Hit:  99.98
Created            13     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients            10     0.0/s
Connects        6.39k     0.0/s

__ Bytes _______________________________________________________________
Sent           33.59G   91.7k/s
Received       11.05G   30.2k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          93.36M of 128.00M  %Used:  72.94
Read ratio      0.000
Pages
  Free          2.22k            %Total:  27.06
  Data          5.30k                     64.67 %Drty:   0.00
  Misc            677                      8.26
  Latched                                  0.00
Reads          39.33M   107.3/s
  From file     4.52k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          2.50M     6.8/s
Flushes       267.11k     0.7/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         4.80k     0.0/s
  Writes      468.52k     1.3/s
  fsync       271.48k     0.7/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created         566     0.0/s
  Read          4.73k     0.0/s
  Written     267.11k     0.7/s

Rows
  Deleted      18.10k     0.0/s
  Inserted     19.94k     0.1/s
  Read         26.79M    73.1/s
  Updated     276.44k     0.8/s

connected from address ec2-44-200-145-223.compute-1.amazonaws.com (44.200.145.223:48062)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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