sunday 08 decembre 2019   -   01 : 51 : 56  
lang fr


Mysql status

MySQL 5.5.62-0+deb8u1-l  uptime 8 14:10:5       Sun Dec  8 01:50:02 2019

__ Key _________________________________________________________________
Buffer used    10.17M of 128.00M  %Used:   7.95
  Current      26.15M            %Usage:  20.43
Write ratio     0.522
Read ratio      0.007

__ Questions ___________________________________________________________
Total          25.60M    34.5/s
  QC Hits      12.25M    16.5/s  %Total:  47.85
  DMS           8.72M    11.8/s           34.06
  Com_          3.80M     5.1/s           14.83
  COM_QUIT    835.73k     1.1/s            3.26
  -Unknown      1.49k     0.0/s            0.01
Slow            5.68k     0.0/s            0.02  %DMS:   0.07
DMS             8.72M    11.8/s           34.06
  SELECT        5.12M     6.9/s           19.99         58.69
  UPDATE        2.34M     3.2/s            9.13         26.82
  DELETE      607.35k     0.8/s            2.37          6.96
  INSERT      366.44k     0.5/s            1.43          4.20
  REPLACE     290.26k     0.4/s            1.13          3.33
Com_            3.80M     5.1/s           14.83
  set_option    1.70M     2.3/s            6.63
  change_db     1.65M     2.2/s            6.45
  show_fields  81.64k     0.1/s            0.32

__ SELECT and Sort _____________________________________________________
Scan          925.63k     1.2/s %SELECT:  18.08
Range         847.37k     1.1/s           16.55
Full join      22.72k     0.0/s            0.44
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     443.94k     0.6/s
Sort range    390.20k     0.5/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   45.54M of  64.00M  %Used:  71.16
Block Fragmnt   0.19%
Hits           12.25M    16.5/s
Inserts         3.96M     5.3/s
Insrt:Prune   13.68:1     4.9/s
Hit:Insert     3.10:1

__ Table Locks _________________________________________________________
Waited         10.54k     0.0/s  %Total:   0.12
Immediate       8.88M    12.0/s

__ Tables ______________________________________________________________
Open              442 of         %Cache: 44200.
Opened        235.64k     0.3/s

__ Connections _________________________________________________________
Max used           61 of  200      %Max:  30.50
Total         835.79k     1.1/s

__ Created Temp ________________________________________________________
Disk table    204.53k     0.3/s
Table         414.35k     0.6/s
File                8     0.0/s

__ Threads _____________________________________________________________
Running            14 of   17
Cached             44 of   64      %Hit:  99.99
Created            61     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients           109     0.0/s
Connects           36     0.0/s

__ Bytes _______________________________________________________________
Sent           71.52G   96.4k/s
Received        4.11G    5.5k/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.14k                     99.44 %Drty:   0.00
  Misc             45                      0.55
  Latched                                  0.00
Reads          22.72M    30.6/s
  From file     7.56k     0.0/s            0.03
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes        852.84k     1.1/s
Flushes       224.26k     0.3/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits               5     0.0/s
Current             0
Time acquiring
  Total           190 ms
  Average          38 ms
  Max             102 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         7.73k     0.0/s
  Writes      311.15k     0.4/s
  fsync        96.85k     0.1/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       2.35k     0.0/s
  Read          7.72k     0.0/s
  Written     224.26k     0.3/s

Rows
  Deleted      31.18k     0.0/s
  Inserted     38.35k     0.1/s
  Read         14.99M    20.2/s
  Updated      33.32k     0.0/s

connected from address localhost (127.0.0.1:59724)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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