saturday 04 july 2020   -   00 : 47 : 21  
lang fr


Mysql status

MySQL 5.5.62-0+deb8u1-l  uptime 8 7:31:52       Sat Jul  4 00:40:01 2020

__ Key _________________________________________________________________
Buffer used     9.35M of 128.00M  %Used:   7.30
  Current      24.04M            %Usage:  18.79
Write ratio     0.272
Read ratio      0.013

__ Questions ___________________________________________________________
Total          10.51M    14.6/s
  QC Hits       4.87M     6.8/s  %Total:  46.36
  DMS           3.21M     4.5/s           30.55
  Com_          2.05M     2.9/s           19.52
  COM_QUIT    413.18k     0.6/s            3.93
  -Unknown     38.47k     0.1/s            0.37
Slow              235     0.0/s            0.00  %DMS:   0.01
DMS             3.21M     4.5/s           30.55
  SELECT        2.21M     3.1/s           21.06         68.92
  UPDATE      589.75k     0.8/s            5.61         18.36
  DELETE      192.51k     0.3/s            1.83          5.99
  INSERT      127.09k     0.2/s            1.21          3.96
  REPLACE      88.88k     0.1/s            0.85          2.77
Com_            2.05M     2.9/s           19.52
  set_option  905.30k     1.3/s            8.61
  change_db   771.63k     1.1/s            7.34
  show_fields  82.58k     0.1/s            0.79

__ SELECT and Sort _____________________________________________________
Scan          495.00k     0.7/s %SELECT:  22.36
Range         308.93k     0.4/s           13.95
Full join       3.90k     0.0/s            0.18
Range check         0       0/s            0.00
Full rng join      39     0.0/s            0.00
Sort scan     113.63k     0.2/s
Sort range    286.72k     0.4/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   15.14M of  64.00M  %Used:  23.66
Block Fragmnt   0.06%
Hits            4.87M     6.8/s
Inserts         1.73M     2.4/s
Insrt:Prune   13.26:1     2.2/s
Hit:Insert     2.81:1

__ Table Locks _________________________________________________________
Waited            486     0.0/s  %Total:   0.01
Immediate       3.49M     4.9/s

__ Tables ______________________________________________________________
Open              233 of         %Cache: 23300.
Opened        216.30k     0.3/s

__ Connections _________________________________________________________
Max used           43 of  200      %Max:  21.50
Total         413.18k     0.6/s

__ Created Temp ________________________________________________________
Disk table    218.82k     0.3/s
Table         348.61k     0.5/s
File                7     0.0/s

__ Threads _____________________________________________________________
Running             1 of    3
Cached             40 of   64      %Hit:  99.99
Created            43     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients             3     0.0/s
Connects       31.05k     0.0/s

__ Bytes _______________________________________________________________
Sent           56.88G   79.2k/s
Received        1.61G    2.2k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.97M of 127.98M  %Used:  99.99
Read ratio      0.000
Pages
  Free              1            %Total:   0.01
  Data          8.15k                     99.54 %Drty:   0.00
  Misc             37                      0.45
  Latched                                  0.00
Reads          38.66M    53.8/s
  From file     8.12k     0.0/s            0.02
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          1.14M     1.6/s
Flushes       230.15k     0.3/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         8.45k     0.0/s
  Writes      326.16k     0.5/s
  fsync       108.03k     0.2/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       3.01k     0.0/s
  Read          8.44k     0.0/s
  Written     230.15k     0.3/s

Rows
  Deleted      46.40k     0.1/s
  Inserted     50.20k     0.1/s
  Read         22.13M    30.8/s
  Updated      30.64k     0.0/s

connected from address ec2-35-168-111-204.compute-1.amazonaws.com (35.168.111.204:18957)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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