tuesday 27 octobre 2020   -   15 : 15 : 55  
lang fr


Mysql status

MySQL 10.1.47-MariaDB-0  uptime 0 3:27:37       Tue Oct 27 15:10:01 2020

__ Key _________________________________________________________________
Buffer used     3.14M of 128.00M  %Used:   2.46
  Current      25.00M            %Usage:  19.53
Write ratio     0.565
Read ratio      0.024

__ Questions ___________________________________________________________
Total          86.42k     6.9/s
  DMS          73.26k     5.9/s  %Total:  84.77
  -Unknown     33.13k     2.7/s           38.34
  QC Hits      32.50k     2.6/s           37.61
  Com_          9.03k     0.7/s           10.44
  COM_QUIT      4.77k     0.4/s            5.52
Slow                0       0/s            0.00  %DMS:   0.00
DMS            73.26k     5.9/s           84.77
  SELECT       61.60k     4.9/s           71.28         84.09
  UPDATE        7.51k     0.6/s            8.69         10.25
  INSERT        2.50k     0.2/s            2.90          3.42
  DELETE        1.61k     0.1/s            1.87          2.20
  REPLACE          31     0.0/s            0.04          0.04
Com_            9.03k     0.7/s           10.44
  change_db     4.89k     0.4/s            5.66
  set_option    3.20k     0.3/s            3.70
  admin_comma     618     0.0/s            0.72

__ SELECT and Sort _____________________________________________________
Scan            4.06k     0.3/s %SELECT:   6.58
Range           2.57k     0.2/s            4.17
Full join          60     0.0/s            0.10
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan       1.55k     0.1/s
Sort range      3.16k     0.3/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   29.13M of  64.00M  %Used:  45.51
Block Fragmnt   2.21%
Hits           32.50k     2.6/s
Inserts        27.99k     2.2/s
Insrt:Prune  27.99k:1     2.2/s
Hit:Insert     1.16:1

__ Table Locks _________________________________________________________
Waited              1     0.0/s  %Total:   0.00
Immediate      56.43k     4.5/s

__ Tables ______________________________________________________________
Open              271 of         %Cache: 27100.
Opened            761     0.1/s

__ Connections _________________________________________________________
Max used            6 of  200      %Max:   3.00
Total           4.77k     0.4/s

__ Created Temp ________________________________________________________
Disk table        884     0.1/s
Table           1.41k     0.1/s
File                6     0.0/s

__ Threads _____________________________________________________________
Running             1 of    1
Cached              5 of   64      %Hit:  99.87
Created             6     0.0/s
Slow                0       0/s

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

__ Bytes _______________________________________________________________
Sent          278.30M   22.3k/s
Received       18.90M    1.5k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          27.41M of 127.98M  %Used:  21.41
Read ratio      0.000
Pages
  Free          6.44k            %Total:  78.59
  Data          1.73k                     21.16 %Drty:   3.98
  Misc             21                      0.26
  Latched                                  0.00
Reads           4.36M   350.3/s
  From file     1.46k     0.1/s            0.03
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes         12.09k     1.0/s
Flushes         1.36k     0.1/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         1.78k     0.1/s
  Writes        1.92k     0.2/s
  fsync           666     0.1/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created          23     0.0/s
  Read          1.71k     0.1/s
  Written       1.36k     0.1/s

Rows
  Deleted         605     0.0/s
  Inserted        166     0.0/s
  Read        161.87k    13.0/s
  Updated         134     0.0/s

connected from address ec2-18-234-97-53.compute-1.amazonaws.com (18.234.97.53:18562)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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