sunday 18 aout 2019   -   13 : 09 : 06  
lang fr


Mysql status

MySQL 5.5.62-0+deb8u1-l  uptime 3 23:17:57      Sun Aug 18 13:00:01 2019

__ Key _________________________________________________________________
Buffer used     9.69M of 128.00M  %Used:   7.57
  Current      25.37M            %Usage:  19.82
Write ratio     0.550
Read ratio      0.006

__ Questions ___________________________________________________________
Total           6.91M    20.1/s
  QC Hits       2.99M     8.7/s  %Total:  43.23
  DMS           2.51M     7.3/s           36.30
  Com_          1.20M     3.5/s           17.36
  COM_QUIT    216.30k     0.6/s            3.13
  -Unknown      1.04k     0.0/s            0.02
Slow               70     0.0/s            0.00  %DMS:   0.00
DMS             2.51M     7.3/s           36.30
  SELECT        1.73M     5.1/s           25.10         69.15
  UPDATE      449.42k     1.3/s            6.51         17.92
  DELETE      149.54k     0.4/s            2.16          5.96
  INSERT      102.92k     0.3/s            1.49          4.10
  REPLACE      71.94k     0.2/s            1.04          2.87
Com_            1.20M     3.5/s           17.36
  set_option  559.27k     1.6/s            8.10
  change_db   455.29k     1.3/s            6.59
  show_create  40.11k     0.1/s            0.58

__ SELECT and Sort _____________________________________________________
Scan          392.23k     1.1/s %SELECT:  22.62
Range         297.65k     0.9/s           17.16
Full join       1.89k     0.0/s            0.11
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     202.14k     0.6/s
Sort range    181.50k     0.5/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   30.24M of  64.00M  %Used:  47.26
Block Fragmnt   1.65%
Hits            2.99M     8.7/s
Inserts         1.44M     4.2/s
Insrt:Prune   10.83:1     3.8/s
Hit:Insert     2.08:1

__ Table Locks _________________________________________________________
Waited            513     0.0/s  %Total:   0.02
Immediate       2.45M     7.1/s

__ Tables ______________________________________________________________
Open              338 of         %Cache: 33800.
Opened        117.43k     0.3/s

__ Connections _________________________________________________________
Max used           14 of  200      %Max:   7.00
Total         216.30k     0.6/s

__ Created Temp ________________________________________________________
Disk table     94.13k     0.3/s
Table         188.62k     0.5/s
File                6     0.0/s

__ Threads _____________________________________________________________
Running             1 of    4
Cached             10 of   64      %Hit:  99.99
Created            14     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients             7     0.0/s
Connects           29     0.0/s

__ Bytes _______________________________________________________________
Sent           29.24G   85.2k/s
Received      979.61M    2.9k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         117.25M of 127.98M  %Used:  91.61
Read ratio      0.001
Pages
  Free            687            %Total:   8.39
  Data          7.44k                     90.79 %Drty:   0.00
  Misc             67                      0.82
  Latched                                  0.00
Reads          10.95M    31.9/s
  From file     5.72k     0.0/s            0.05
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes        350.07k     1.0/s
Flushes        88.59k     0.3/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         5.90k     0.0/s
  Writes      122.56k     0.4/s
  fsync        38.13k     0.1/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       1.55k     0.0/s
  Read          5.89k     0.0/s
  Written      88.59k     0.3/s

Rows
  Deleted      13.78k     0.0/s
  Inserted     13.82k     0.0/s
  Read          6.74M    19.7/s
  Updated      14.01k     0.0/s

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

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