friday 18 octobre 2019   -   03 : 20 : 17  
lang fr


Mysql status

MySQL 5.5.62-0+deb8u1-l  uptime 18 7:20:18      Fri Oct 18 03:20:02 2019

__ Key _________________________________________________________________
Buffer used    42.14M of 128.00M  %Used:  32.92
  Current      28.65M            %Usage:  22.38
Write ratio     0.448
Read ratio      0.001

__ Questions ___________________________________________________________
Total          46.11M    29.2/s
  QC Hits      21.46M    13.6/s  %Total:  46.53
  DMS          16.03M    10.1/s           34.76
  Com_          7.46M     4.7/s           16.17
  COM_QUIT      1.19M     0.7/s            2.57
  -Unknown     13.04k     0.0/s            0.03
Slow            3.08k     0.0/s            0.01  %DMS:   0.02
DMS            16.03M    10.1/s           34.76
  SELECT       10.37M     6.6/s           22.48         64.69
  UPDATE        3.53M     2.2/s            7.65         22.01
  DELETE        1.02M     0.6/s            2.21          6.36
  REPLACE     625.65k     0.4/s            1.36          3.90
  INSERT      485.87k     0.3/s            1.05          3.03
Com_            7.46M     4.7/s           16.17
  change_db     3.22M     2.0/s            6.98
  set_option    3.06M     1.9/s            6.64
  repair      339.04k     0.2/s            0.74

__ SELECT and Sort _____________________________________________________
Scan            2.05M     1.3/s %SELECT:  19.79
Range           1.92M     1.2/s           18.54
Full join       7.30k     0.0/s            0.07
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan       1.18M     0.7/s
Sort range      1.32M     0.8/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   42.68M of  64.00M  %Used:  66.69
Block Fragmnt   0.76%
Hits           21.46M    13.6/s
Inserts         8.50M     5.4/s
Insrt:Prune   26.66:1     5.2/s
Hit:Insert     2.52:1

__ Table Locks _________________________________________________________
Waited         27.77k     0.0/s  %Total:   0.19
Immediate      14.85M     9.4/s

__ Tables ______________________________________________________________
Open              402 of         %Cache: 40200.
Opened        475.13k     0.3/s

__ Connections _________________________________________________________
Max used           56 of  200      %Max:  28.00
Total           1.19M     0.7/s

__ Created Temp ________________________________________________________
Disk table    449.49k     0.3/s
Table         856.72k     0.5/s
File               10     0.0/s

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

__ Aborted _____________________________________________________________
Clients           328     0.0/s
Connects           67     0.0/s

__ Bytes _______________________________________________________________
Sent          307.80G  194.6k/s
Received        7.04G    4.5k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.95M of 127.98M  %Used:  99.98
Read ratio      0.000
Pages
  Free              2            %Total:   0.02
  Data          8.11k                     99.00 %Drty:   0.00
  Misc             80                      0.98
  Latched                                  0.00
Reads          50.32M    31.8/s
  From file     8.92k     0.0/s            0.02
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          1.86M     1.2/s
Flushes       386.35k     0.2/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits               6     0.0/s
Current             0
Time acquiring
  Total           208 ms
  Average          34 ms
  Max             126 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         9.29k     0.0/s
  Writes      534.25k     0.3/s
  fsync       163.74k     0.1/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       4.77k     0.0/s
  Read          9.28k     0.0/s
  Written     386.35k     0.2/s

Rows
  Deleted      80.42k     0.1/s
  Inserted     64.00k     0.0/s
  Read         33.22M    21.0/s
  Updated      58.98k     0.0/s

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

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