tuesday 30 novembre 2021   -   06 : 09 : 03  
lang fr


Mysql status

MySQL 10.1.48-MariaDB-0  uptime 29 7:30:9       Tue Nov 30 06:00:03 2021

__ Key _________________________________________________________________
Buffer used    39.65M of 128.00M  %Used:  30.97
  Current      29.23M            %Usage:  22.83
Write ratio     0.564
Read ratio      0.022

__ Questions ___________________________________________________________
Total          19.23M     7.6/s
  DMS          13.80M     5.4/s  %Total:  71.76
  -Unknown      7.02M     2.8/s           36.52
  QC Hits       6.92M     2.7/s           35.99
  Com_          4.31M     1.7/s           22.44
  COM_QUIT      1.22M     0.5/s            6.33
Slow            1.43k     0.0/s            0.01  %DMS:   0.01
DMS            13.80M     5.4/s           71.76
  SELECT       11.90M     4.7/s           61.86         86.21
  UPDATE        1.21M     0.5/s            6.31          8.80
  INSERT      452.99k     0.2/s            2.36          3.28
  DELETE      232.03k     0.1/s            1.21          1.68
  REPLACE       4.36k     0.0/s            0.02          0.03
Com_            4.31M     1.7/s           22.44
  set_option    2.02M     0.8/s           10.48
  change_db     1.55M     0.6/s            8.04
  show_fields 309.08k     0.1/s            1.61

__ SELECT and Sort _____________________________________________________
Scan            1.87M     0.7/s %SELECT:  15.74
Range         552.42k     0.2/s            4.64
Full join      10.28k     0.0/s            0.09
Range check         0       0/s            0.00
Full rng join      12     0.0/s            0.00
Sort scan     378.54k     0.1/s
Sort range     70.80k     0.0/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   31.31M of  64.00M  %Used:  48.92
Block Fragmnt   4.03%
Hits            6.92M     2.7/s
Inserts         3.55M     1.4/s
Insrt:Prune  273.61:1     1.4/s
Hit:Insert     1.95:1

__ Table Locks _________________________________________________________
Waited          1.04k     0.0/s  %Total:   0.01
Immediate       9.15M     3.6/s

__ Tables ______________________________________________________________
Open            1.02k of         %Cache: 102400
Opened        656.04k     0.3/s

__ Connections _________________________________________________________
Max used           43 of  200      %Max:  21.50
Total           1.22M     0.5/s

__ Created Temp ________________________________________________________
Disk table    845.24k     0.3/s
Table           1.31M     0.5/s
File                6     0.0/s

__ Threads _____________________________________________________________
Running             1 of    4
Cached             39 of   64      %Hit:    100
Created            43     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients             5     0.0/s
Connects        5.25k     0.0/s

__ Bytes _______________________________________________________________
Sent          179.66G   70.9k/s
Received        3.71G    1.5k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          62.62M of 127.98M  %Used:  48.93
Read ratio      0.000
Pages
  Free          4.18k            %Total:  51.07
  Data          3.98k                     48.65 %Drty:   0.60
  Misc             23                      0.28
  Latched                                  0.00
Reads         925.47M   365.4/s
  From file     3.53k     0.0/s            0.00
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes         31.52k     0.0/s
Flushes        13.12k     0.0/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         4.01k     0.0/s
  Writes       20.89k     0.0/s
  fsync         9.28k     0.0/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created          95     0.0/s
  Read          3.89k     0.0/s
  Written      13.12k     0.0/s

Rows
  Deleted           0       0/s
  Inserted        478     0.0/s
  Read         54.63M    21.6/s
  Updated       3.27k     0.0/s

connected from address ec2-34-207-247-69.compute-1.amazonaws.com (34.207.247.69:14056)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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