tuesday 07 april 2020   -   20 : 41 : 42  
lang fr


Mysql status

MySQL 5.5.62-0+deb8u1-l  uptime 13 23:58:19     Tue Apr  7 20:40:02 2020

__ Key _________________________________________________________________
Buffer used    12.63M of 128.00M  %Used:   9.87
  Current      24.59M            %Usage:  19.21
Write ratio     0.578
Read ratio      0.010

__ Questions ___________________________________________________________
Total          23.83M    19.7/s
  QC Hits      10.58M     8.7/s  %Total:  44.39
  DMS           8.58M     7.1/s           36.01
  Com_          3.87M     3.2/s           16.26
  COM_QUIT    793.90k     0.7/s            3.33
  +Unknown      2.84k     0.0/s            0.01
Slow            3.37k     0.0/s            0.01  %DMS:   0.04
DMS             8.58M     7.1/s           36.01
  SELECT        5.73M     4.7/s           24.03         66.75
  UPDATE        1.69M     1.4/s            7.08         19.65
  INSERT      582.07k     0.5/s            2.44          6.78
  DELETE      412.43k     0.3/s            1.73          4.81
  REPLACE     172.38k     0.1/s            0.72          2.01
Com_            3.87M     3.2/s           16.26
  set_option    1.88M     1.6/s            7.89
  change_db     1.36M     1.1/s            5.70
  show_fields 143.32k     0.1/s            0.60

__ SELECT and Sort _____________________________________________________
Scan            1.76M     1.5/s %SELECT:  30.66
Range           1.05M     0.9/s           18.32
Full join       8.26k     0.0/s            0.14
Range check         0       0/s            0.00
Full rng join       8     0.0/s            0.00
Sort scan     882.91k     0.7/s
Sort range    393.53k     0.3/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   13.91M of  64.00M  %Used:  21.73
Block Fragmnt   0.18%
Hits           10.58M     8.7/s
Inserts         4.80M     4.0/s
Insrt:Prune   13.10:1     3.7/s
Hit:Insert     2.20:1

__ Table Locks _________________________________________________________
Waited          4.20k     0.0/s  %Total:   0.04
Immediate       9.48M     7.8/s

__ Tables ______________________________________________________________
Open              228 of         %Cache: 22800.
Opened        372.14k     0.3/s

__ Connections _________________________________________________________
Max used           64 of  200      %Max:  32.00
Total         794.34k     0.7/s

__ Created Temp ________________________________________________________
Disk table    352.04k     0.3/s
Table         693.92k     0.6/s
File                8     0.0/s

__ Threads _____________________________________________________________
Running             1 of    2
Cached             62 of   64      %Hit:  99.99
Created            64     0.0/s
Slow                1     0.0/s

__ Aborted _____________________________________________________________
Clients           890     0.0/s
Connects          641     0.0/s

__ Bytes _______________________________________________________________
Sent          106.25G   87.8k/s
Received        4.25G    3.5k/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.15k                     99.54 %Drty:   0.00
  Misc             38                      0.46
  Latched                                  0.00
Reads          32.10M    26.5/s
  From file     8.30k     0.0/s            0.03
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          1.81M     1.5/s
Flushes       330.58k     0.3/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits              27     0.0/s
Current             0
Time acquiring
  Total           263 ms
  Average           9 ms
  Max             246 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         8.61k     0.0/s
  Writes      469.25k     0.4/s
  fsync       155.98k     0.1/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       5.34k     0.0/s
  Read          8.60k     0.0/s
  Written     330.58k     0.3/s

Rows
  Deleted      75.19k     0.1/s
  Inserted     72.85k     0.1/s
  Read         18.29M    15.1/s
  Updated      40.11k     0.0/s

connected from address ec2-3-235-30-155.compute-1.amazonaws.com (3.235.30.155:26507)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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