vendredi 09 juin 2023   -   20 : 21 : 56  
lang en


Mysql status

MySQL 10.3.39-MariaDB-0  uptime 4 7:7:11        Fri Jun  9 20:20:01 2023

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

__ Questions ___________________________________________________________
Total           9.02M    24.3/s
  DMS           8.56M    23.0/s  %Total:  94.88
  Com_        598.55k     1.6/s            6.64
  -Unknown    473.27k     1.3/s            5.25
  QC Hits     270.50k     0.7/s            3.00
  COM_QUIT     65.51k     0.2/s            0.73
Slow               17     0.0/s            0.00  %DMS:   0.00
DMS             8.56M    23.0/s           94.88
  INSERT        7.95M    21.4/s           88.17         92.92
  SELECT      531.27k     1.4/s            5.89          6.21
  UPDATE       73.10k     0.2/s            0.81          0.85
  DELETE        1.10k     0.0/s            0.01          0.01
  REPLACE           2     0.0/s            0.00          0.00
Com_          598.55k     1.6/s            6.64
  set_option  217.44k     0.6/s            2.41
  change_db    90.88k     0.2/s            1.01
  stmt_execut  78.36k     0.2/s            0.87

__ SELECT and Sort _____________________________________________________
Scan          177.20k     0.5/s %SELECT:  33.35
Range           5.41k     0.0/s            1.02
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.37k     0.1/s
Sort range     12.96k     0.0/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage    1.74M of  64.00M  %Used:   2.71
Block Fragmnt   1.40%
Hits          270.50k     0.7/s
Inserts        80.58k     0.2/s
Insrt:Prune  80.58k:1     0.2/s
Hit:Insert     3.36:1

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

__ Tables ______________________________________________________________
Open              110 of         %Cache: 11000.
Opened         76.55k     0.2/s

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

__ Created Temp ________________________________________________________
Disk table     93.65k     0.3/s
Table         152.78k     0.4/s
File                5     0.0/s

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

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

__ Bytes _______________________________________________________________
Sent           33.82G   91.1k/s
Received       11.21G   30.2k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          93.34M of 128.00M  %Used:  72.92
Read ratio      0.000
Pages
  Free          2.22k            %Total:  27.08
  Data          5.30k                     64.69 %Drty:   0.00
  Misc            675                      8.24
  Latched                                  0.00
Reads          40.12M   108.1/s
  From file     4.52k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          2.55M     6.9/s
Flushes       272.21k     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      476.68k     1.3/s
  fsync       275.72k     0.7/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created         567     0.0/s
  Read          4.73k     0.0/s
  Written     272.21k     0.7/s

Rows
  Deleted      18.94k     0.1/s
  Inserted     20.51k     0.1/s
  Read         27.25M    73.4/s
  Updated     280.94k     0.8/s

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

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