friday 23 aout 2019   -   00 : 42 : 24  
lang fr


Mysql status

MySQL 5.5.62-0+deb8u1-l  uptime 8 10:57:58      Fri Aug 23 00:40:02 2019

__ Key _________________________________________________________________
Buffer used    11.31M of 128.00M  %Used:   8.84
  Current      24.46M            %Usage:  19.11
Write ratio     0.569
Read ratio      0.006

__ Questions ___________________________________________________________
Total          15.15M    20.7/s
  QC Hits       6.56M     9.0/s  %Total:  43.32
  DMS           5.54M     7.6/s           36.57
  Com_          2.58M     3.5/s           17.03
  COM_QUIT    470.23k     0.6/s            3.10
  -Unknown      2.67k     0.0/s            0.02
Slow              172     0.0/s            0.00  %DMS:   0.00
DMS             5.54M     7.6/s           36.57
  SELECT        3.82M     5.2/s           25.22         68.96
  UPDATE      998.47k     1.4/s            6.59         18.03
  DELETE      340.08k     0.5/s            2.25          6.14
  INSERT      214.47k     0.3/s            1.42          3.87
  REPLACE     166.14k     0.2/s            1.10          3.00
Com_            2.58M     3.5/s           17.03
  set_option    1.20M     1.6/s            7.90
  change_db     1.00M     1.4/s            6.63
  show_table_  80.73k     0.1/s            0.53

__ SELECT and Sort _____________________________________________________
Scan          820.06k     1.1/s %SELECT:  21.47
Range         684.87k     0.9/s           17.93
Full join       3.90k     0.0/s            0.10
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     434.20k     0.6/s
Sort range    384.69k     0.5/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   15.65M of  64.00M  %Used:  24.46
Block Fragmnt   0.32%
Hits            6.56M     9.0/s
Inserts         3.19M     4.4/s
Insrt:Prune    9.90:1     3.9/s
Hit:Insert     2.06:1

__ Table Locks _________________________________________________________
Waited          1.60k     0.0/s  %Total:   0.03
Immediate       5.37M     7.4/s

__ Tables ______________________________________________________________
Open              207 of         %Cache: 20700.
Opened        220.47k     0.3/s

__ Connections _________________________________________________________
Max used           15 of  200      %Max:   7.50
Total         470.25k     0.6/s

__ Created Temp ________________________________________________________
Disk table    191.79k     0.3/s
Table         394.49k     0.5/s
File                7     0.0/s

__ Threads _____________________________________________________________
Running             1 of    1
Cached             14 of   64      %Hit:    100
Created            15     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients            42     0.0/s
Connects           45     0.0/s

__ Bytes _______________________________________________________________
Sent           61.81G   84.6k/s
Received        2.15G    2.9k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.98M of 127.98M  %Used: 100.00
Read ratio      0.000
Pages
  Free              0            %Total:   0.00
  Data          8.13k                     99.29 %Drty:   0.00
  Misc             58                      0.71
  Latched                                  0.00
Reads          22.23M    30.4/s
  From file     7.38k     0.0/s            0.03
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes        624.49k     0.9/s
Flushes       166.66k     0.2/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         7.56k     0.0/s
  Writes      229.44k     0.3/s
  fsync        70.99k     0.1/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       2.60k     0.0/s
  Read          7.55k     0.0/s
  Written     166.66k     0.2/s

Rows
  Deleted      24.58k     0.0/s
  Inserted     24.99k     0.0/s
  Read         14.00M    19.2/s
  Updated      25.79k     0.0/s

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

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