wednesday 03 june 2020   -   13 : 35 : 41  
lang fr


Mysql status

MySQL 5.5.62-0+deb8u1-l  uptime 28 0:24:57      Wed Jun  3 13:30:02 2020

__ Key _________________________________________________________________
Buffer used    14.70M of 128.00M  %Used:  11.48
  Current      26.51M            %Usage:  20.71
Write ratio     0.491
Read ratio      0.013

__ Questions ___________________________________________________________
Total          49.95M    20.6/s
  QC Hits      22.50M     9.3/s  %Total:  45.05
  DMS          17.34M     7.2/s           34.72
  Com_          8.42M     3.5/s           16.86
  COM_QUIT      1.68M     0.7/s            3.36
  +Unknown      7.16k     0.0/s            0.01
Slow              838     0.0/s            0.00  %DMS:   0.00
DMS            17.34M     7.2/s           34.72
  SELECT       12.01M     5.0/s           24.05         69.28
  UPDATE        3.06M     1.3/s            6.13         17.66
  DELETE      937.25k     0.4/s            1.88          5.41
  INSERT      892.02k     0.4/s            1.79          5.14
  REPLACE     434.38k     0.2/s            0.87          2.51
Com_            8.42M     3.5/s           16.86
  set_option    4.00M     1.7/s            8.02
  change_db     3.13M     1.3/s            6.27
  show_fields 286.61k     0.1/s            0.57

__ SELECT and Sort _____________________________________________________
Scan            3.19M     1.3/s %SELECT:  26.59
Range           2.16M     0.9/s           17.98
Full join      18.44k     0.0/s            0.15
Range check         0       0/s            0.00
Full rng join      25     0.0/s            0.00
Sort scan       1.69M     0.7/s
Sort range      1.33M     0.5/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   42.56M of  64.00M  %Used:  66.49
Block Fragmnt   1.23%
Hits           22.50M     9.3/s
Inserts         9.96M     4.1/s
Insrt:Prune    7.32:1     3.6/s
Hit:Insert     2.26:1

__ Table Locks _________________________________________________________
Waited          1.97k     0.0/s  %Total:   0.01
Immediate      18.27M     7.5/s

__ Tables ______________________________________________________________
Open              431 of         %Cache: 43100.
Opened        725.60k     0.3/s

__ Connections _________________________________________________________
Max used           38 of  200      %Max:  19.00
Total           1.68M     0.7/s

__ Created Temp ________________________________________________________
Disk table    756.30k     0.3/s
Table           1.44M     0.6/s
File               11     0.0/s

__ Threads _____________________________________________________________
Running             2 of    3
Cached             35 of   64      %Hit:    100
Created            38     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients           875     0.0/s
Connects          756     0.0/s

__ Bytes _______________________________________________________________
Sent          219.29G   90.6k/s
Received        8.23G    3.4k/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.55 %Drty:   0.10
  Misc             36                      0.44
  Latched                                  0.00
Reads          96.73M    40.0/s
  From file     9.43k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          3.81M     1.6/s
Flushes       680.62k     0.3/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         9.68k     0.0/s
  Writes      966.11k     0.4/s
  fsync       320.06k     0.1/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       7.37k     0.0/s
  Read          9.67k     0.0/s
  Written     680.62k     0.3/s

Rows
  Deleted     161.73k     0.1/s
  Inserted    146.44k     0.1/s
  Read         61.92M    25.6/s
  Updated      84.98k     0.0/s

connected from address ec2-18-232-38-214.compute-1.amazonaws.com (18.232.38.214:57006)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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