lundi 25 janvier 2021   -   11 : 51 : 42  
lang en


Mysql status

MySQL 10.1.47-MariaDB-0  uptime 2 18:18:53      Mon Jan 25 11:50:01 2021

__ Key _________________________________________________________________
Buffer used     4.73M of 128.00M  %Used:   3.69
  Current      25.11M            %Usage:  19.62
Write ratio     0.588
Read ratio      0.022

__ Questions ___________________________________________________________
Total           1.96M     8.2/s
  DMS           1.45M     6.1/s  %Total:  74.17
  -Unknown    771.26k     3.2/s           39.44
  QC Hits     723.94k     3.0/s           37.02
  Com_        452.70k     1.9/s           23.15
  COM_QUIT     99.81k     0.4/s            5.10
Slow               37     0.0/s            0.00  %DMS:   0.00
DMS             1.45M     6.1/s           74.17
  SELECT        1.22M     5.1/s           62.44         84.19
  UPDATE      147.37k     0.6/s            7.54         10.16
  INSERT       56.03k     0.2/s            2.86          3.86
  DELETE       25.57k     0.1/s            1.31          1.76
  REPLACE         397     0.0/s            0.02          0.03
Com_          452.70k     1.9/s           23.15
  set_option  207.66k     0.9/s           10.62
  change_db   131.70k     0.6/s            6.73
  admin_comma  46.60k     0.2/s            2.38

__ SELECT and Sort _____________________________________________________
Scan          185.25k     0.8/s %SELECT:  15.17
Range          59.45k     0.2/s            4.87
Full join         723     0.0/s            0.06
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan      31.42k     0.1/s
Sort range      6.77k     0.0/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   30.66M of  64.00M  %Used:  47.91
Block Fragmnt   2.34%
Hits          723.94k     3.0/s
Inserts       361.03k     1.5/s
Insrt:Prune 361.03k:1     1.5/s
Hit:Insert     2.01:1

__ Table Locks _________________________________________________________
Waited            263     0.0/s  %Total:   0.03
Immediate     970.06k     4.1/s

__ Tables ______________________________________________________________
Open              199 of         %Cache: 19900.
Opened         64.60k     0.3/s

__ Connections _________________________________________________________
Max used            8 of  200      %Max:   4.00
Total          99.81k     0.4/s

__ Created Temp ________________________________________________________
Disk table     80.86k     0.3/s
Table         125.79k     0.5/s
File                6     0.0/s

__ Threads _____________________________________________________________
Running             1 of    1
Cached              7 of   64      %Hit:  99.99
Created             8     0.0/s
Slow                0       0/s

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

__ Bytes _______________________________________________________________
Sent           17.34G   72.7k/s
Received      401.70M    1.7k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          80.17M of 127.98M  %Used:  62.64
Read ratio      0.000
Pages
  Free          3.06k            %Total:  37.36
  Data          5.09k                     62.14 %Drty:   0.57
  Misc             41                      0.50
  Latched                                  0.00
Reads          84.84M   355.4/s
  From file     4.56k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes         56.30k     0.2/s
Flushes         8.36k     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         5.37k     0.0/s
  Writes       12.43k     0.1/s
  fsync         4.93k     0.0/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created          38     0.0/s
  Read          5.05k     0.0/s
  Written       8.36k     0.0/s

Rows
  Deleted       2.31k     0.0/s
  Inserted        971     0.0/s
  Read          3.54M    14.8/s
  Updated       2.31k     0.0/s

connected from address ec2-18-204-42-98.compute-1.amazonaws.com (18.204.42.98:48098)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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