friday 13 decembre 2019   -   23 : 20 : 16  
lang fr


Mysql status

MySQL 5.5.62-0+deb8u1-l  uptime 14 11:40:4      Fri Dec 13 23:20:01 2019

__ Key _________________________________________________________________
Buffer used    10.17M of 128.00M  %Used:   7.95
  Current      25.92M            %Usage:  20.25
Write ratio     0.525
Read ratio      0.007

__ Questions ___________________________________________________________
Total          42.14M    33.7/s
  QC Hits      20.23M    16.2/s  %Total:  48.00
  DMS          14.06M    11.2/s           33.36
  Com_          6.46M     5.2/s           15.32
  COM_QUIT      1.40M     1.1/s            3.33
  -Unknown      2.70k     0.0/s            0.01
Slow            5.92k     0.0/s            0.01  %DMS:   0.04
DMS            14.06M    11.2/s           33.36
  SELECT        8.19M     6.5/s           19.44         58.27
  UPDATE        3.81M     3.0/s            9.04         27.08
  DELETE      982.38k     0.8/s            2.33          6.99
  INSERT      588.37k     0.5/s            1.40          4.18
  REPLACE     487.88k     0.4/s            1.16          3.47
Com_            6.46M     5.2/s           15.32
  set_option    2.88M     2.3/s            6.83
  change_db     2.79M     2.2/s            6.63
  repair      143.48k     0.1/s            0.34

__ SELECT and Sort _____________________________________________________
Scan            1.61M     1.3/s %SELECT:  19.59
Range           1.41M     1.1/s           17.22
Full join      34.78k     0.0/s            0.42
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     768.07k     0.6/s
Sort range    644.97k     0.5/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   41.28M of  64.00M  %Used:  64.50
Block Fragmnt   0.22%
Hits           20.23M    16.2/s
Inserts         6.30M     5.0/s
Insrt:Prune   17.79:1     4.8/s
Hit:Insert     3.21:1

__ Table Locks _________________________________________________________
Waited         12.38k     0.0/s  %Total:   0.09
Immediate      14.18M    11.3/s

__ Tables ______________________________________________________________
Open              381 of         %Cache: 38100.
Opened        386.25k     0.3/s

__ Connections _________________________________________________________
Max used           62 of  200      %Max:  31.00
Total           1.40M     1.1/s

__ Created Temp ________________________________________________________
Disk table    354.32k     0.3/s
Table         698.70k     0.6/s
File                8     0.0/s

__ Threads _____________________________________________________________
Running             1 of    6
Cached             56 of   64      %Hit:    100
Created            62     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients           176     0.0/s
Connects           61     0.0/s

__ Bytes _______________________________________________________________
Sent          120.53G   96.3k/s
Received        6.83G    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.15k                     99.51 %Drty:   0.00
  Misc             39                      0.48
  Latched                                  0.00
Reads          37.74M    30.2/s
  From file     8.08k     0.0/s            0.02
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          1.30M     1.0/s
Flushes       342.52k     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         8.25k     0.0/s
  Writes      474.83k     0.4/s
  fsync       147.54k     0.1/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       3.21k     0.0/s
  Read          8.24k     0.0/s
  Written     342.52k     0.3/s

Rows
  Deleted      47.82k     0.0/s
  Inserted     57.23k     0.0/s
  Read         24.67M    19.7/s
  Updated      52.31k     0.0/s

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

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