thirsday 17 octobre 2019   -   15 : 12 : 29  
lang fr


Mysql status

MySQL 5.5.62-0+deb8u1-l  uptime 17 19:10:17     Thu Oct 17 15:10:01 2019

__ Key _________________________________________________________________
Buffer used    42.14M of 128.00M  %Used:  32.92
  Current      27.88M            %Usage:  21.78
Write ratio     0.446
Read ratio      0.001

__ Questions ___________________________________________________________
Total          45.06M    29.3/s
  QC Hits      20.95M    13.6/s  %Total:  46.51
  DMS          15.65M    10.2/s           34.72
  Com_          7.32M     4.8/s           16.24
  COM_QUIT      1.15M     0.7/s            2.56
  -Unknown     12.90k     0.0/s            0.03
Slow            3.01k     0.0/s            0.01  %DMS:   0.02
DMS            15.65M    10.2/s           34.72
  SELECT       10.12M     6.6/s           22.46         64.67
  UPDATE        3.45M     2.2/s            7.65         22.03
  DELETE      996.23k     0.6/s            2.21          6.37
  REPLACE     611.62k     0.4/s            1.36          3.91
  INSERT      471.98k     0.3/s            1.05          3.02
Com_            7.32M     4.8/s           16.24
  change_db     3.14M     2.0/s            6.98
  set_option    3.01M     2.0/s            6.67
  repair      332.98k     0.2/s            0.74

__ SELECT and Sort _____________________________________________________
Scan            2.01M     1.3/s %SELECT:  19.83
Range           1.88M     1.2/s           18.53
Full join       7.11k     0.0/s            0.07
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan       1.14M     0.7/s
Sort range      1.30M     0.8/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   28.71M of  64.00M  %Used:  44.86
Block Fragmnt   1.88%
Hits           20.95M    13.6/s
Inserts         8.29M     5.4/s
Insrt:Prune   25.99:1     5.2/s
Hit:Insert     2.53:1

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

__ Tables ______________________________________________________________
Open              349 of         %Cache: 34900.
Opened        472.33k     0.3/s

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

__ Created Temp ________________________________________________________
Disk table    446.86k     0.3/s
Table         846.90k     0.6/s
File               10     0.0/s

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

__ Aborted _____________________________________________________________
Clients           321     0.0/s
Connects           63     0.0/s

__ Bytes _______________________________________________________________
Sent          301.39G  196.0k/s
Received        6.88G    4.5k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.86M of 127.98M  %Used:  99.90
Read ratio      0.000
Pages
  Free              8            %Total:   0.10
  Data          8.10k                     98.93 %Drty:   0.00
  Misc             80                      0.98
  Latched                                  0.00
Reads          49.25M    32.0/s
  From file     8.92k     0.0/s            0.02
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          1.81M     1.2/s
Flushes       372.02k     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      514.57k     0.3/s
  fsync       157.82k     0.1/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       4.55k     0.0/s
  Read          9.28k     0.0/s
  Written     372.02k     0.2/s

Rows
  Deleted      78.94k     0.1/s
  Inserted     62.08k     0.0/s
  Read         32.57M    21.2/s
  Updated      56.14k     0.0/s

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

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