lundi 15 octobre 2018   -   15 : 20 : 05  
lang en


Mysql status

MySQL 5.5.60-0+deb7u1-l  uptime 1 2:47:51       Mon Oct 15 15:20:01 2018

__ Key _________________________________________________________________
Buffer used    21.53M of 128.00M  %Used:  16.82
  Current      44.87M            %Usage:  35.05
Write ratio     0.606
Read ratio      0.002

__ Questions ___________________________________________________________
Total           2.33M    24.1/s
  Com_          1.78M    18.4/s  %Total:  76.30
  -Unknown      1.58M    16.4/s           68.10
  DMS           1.35M    14.0/s           58.04
  QC Hits     721.28k     7.5/s           31.00
  COM_QUIT     64.15k     0.7/s            2.76
Slow                3     0.0/s            0.00  %DMS:   0.00
DMS             1.35M    14.0/s           58.04
  SELECT        1.16M    12.0/s           49.73         85.68
  UPDATE      109.98k     1.1/s            4.73          8.14
  INSERT       36.60k     0.4/s            1.57          2.71
  DELETE       31.96k     0.3/s            1.37          2.37
  REPLACE      14.81k     0.2/s            0.64          1.10
Com_            1.78M    18.4/s           76.30
  admin_comma   1.58M    16.4/s           68.09
  set_option   99.32k     1.0/s            4.27
  change_db    86.98k     0.9/s            3.74

__ SELECT and Sort _____________________________________________________
Scan           85.80k     0.9/s %SELECT:   7.41
Range         105.91k     1.1/s            9.15
Full join         549     0.0/s            0.05
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan      44.95k     0.5/s
Sort range     50.76k     0.5/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   54.23M of  64.00M  %Used:  84.73
Block Fragmnt  14.45%
Hits          721.28k     7.5/s
Inserts         1.09M    11.3/s
Insrt:Prune   10.05:1    10.2/s
Hit:Insert     0.66:1

__ Table Locks _________________________________________________________
Waited             48     0.0/s  %Total:   0.00
Immediate       1.34M    13.9/s

__ Tables ______________________________________________________________
Open            1.02k of         %Cache: 102300
Opened         17.74k     0.2/s

__ Connections _________________________________________________________
Max used           17 of  200      %Max:   8.50
Total          64.15k     0.7/s

__ Created Temp ________________________________________________________
Disk table      3.31k     0.0/s
Table          32.12k     0.3/s
File                6     0.0/s

__ Threads _____________________________________________________________
Running             1 of    3
Cached             14 of   64      %Hit:  99.97
Created            17     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients            10     0.0/s
Connects            8     0.0/s

__ Bytes _______________________________________________________________
Sent            7.20G   74.7k/s
Received      340.22M    3.5k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          70.64M of 127.98M  %Used:  55.19
Read ratio      0.001
Pages
  Free          3.67k            %Total:  44.81
  Data          4.48k                     54.73 %Drty:   0.51
  Misc             38                      0.46
  Latched                                  0.00
Reads           3.32M    34.4/s
  From file     4.07k     0.0/s            0.12
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes        142.26k     1.5/s
Flushes        33.42k     0.3/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         4.23k     0.0/s
  Writes       47.10k     0.5/s
  fsync        15.53k     0.2/s
  Pending
    Reads           0
    Writes          0
    fysnc           1

Pages
  Created         390     0.0/s
  Read          4.09k     0.0/s
  Written      33.42k     0.3/s

Rows
  Deleted       6.22k     0.1/s
  Inserted      6.54k     0.1/s
  Read          1.79M    18.6/s
  Updated       4.10k     0.0/s

connected from address ec2-54-198-15-20.compute-1.amazonaws.com (54.198.15.20:48752)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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