vendredi 21 septembre 2018   -   10 : 43 : 24  
lang en


Mysql status

MySQL 5.5.60-0+deb7u1-l  uptime 10 23:53:2      Fri Sep 21 10:40:01 2018

__ Key _________________________________________________________________
Buffer used    40.36M of 128.00M  %Used:  31.53
  Current      63.70M            %Usage:  49.76
Write ratio     0.567
Read ratio      0.001

__ Questions ___________________________________________________________
Total          17.32M    18.2/s
  Com_         13.81M    14.5/s  %Total:  79.75
  -Unknown     12.62M    13.3/s           72.89
  DMS           9.74M    10.3/s           56.26
  QC Hits       6.03M     6.3/s           34.80
  COM_QUIT    361.23k     0.4/s            2.09
Slow                9     0.0/s            0.00  %DMS:   0.00
DMS             9.74M    10.3/s           56.26
  SELECT        8.52M     9.0/s           49.19         87.44
  UPDATE      702.47k     0.7/s            4.06          7.21
  INSERT      228.62k     0.2/s            1.32          2.35
  DELETE      203.34k     0.2/s            1.17          2.09
  REPLACE      89.15k     0.1/s            0.51          0.92
Com_           13.81M    14.5/s           79.75
  admin_comma  12.62M    13.3/s           72.88
  set_option  621.82k     0.7/s            3.59
  change_db   538.21k     0.6/s            3.11

__ SELECT and Sort _____________________________________________________
Scan          568.81k     0.6/s %SELECT:   6.68
Range         536.10k     0.6/s            6.29
Full join       3.73k     0.0/s            0.04
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     223.77k     0.2/s
Sort range    293.97k     0.3/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   55.09M of  64.00M  %Used:  86.08
Block Fragmnt  10.75%
Hits            6.03M     6.3/s
Inserts         8.20M     8.6/s
Insrt:Prune    9.84:1     7.8/s
Hit:Insert     0.73:1

__ Table Locks _________________________________________________________
Waited            337     0.0/s  %Total:   0.00
Immediate       9.80M    10.3/s

__ Tables ______________________________________________________________
Open            1.01k of         %Cache: 100800
Opened         18.49k     0.0/s

__ Connections _________________________________________________________
Max used           12 of  200      %Max:   6.00
Total         361.23k     0.4/s

__ Created Temp ________________________________________________________
Disk table     22.47k     0.0/s
Table         169.43k     0.2/s
File                8     0.0/s

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

__ Aborted _____________________________________________________________
Clients             4     0.0/s
Connects          116     0.0/s

__ Bytes _______________________________________________________________
Sent           50.91G   53.6k/s
Received        2.53G    2.7k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.98M of 128.00M  %Used:  99.99
Read ratio      0.000
Pages
  Free              1            %Total:   0.01
  Data          8.13k                     99.27 %Drty:   0.00
  Misc             59                      0.72
  Latched                                  0.00
Reads          32.78M    34.5/s
  From file     4.58k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          1.78M     1.9/s
Flushes       416.88k     0.4/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         4.97k     0.0/s
  Writes      591.08k     0.6/s
  fsync       196.22k     0.2/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       3.76k     0.0/s
  Read          4.83k     0.0/s
  Written     416.88k     0.4/s

Rows
  Deleted      72.13k     0.1/s
  Inserted     88.18k     0.1/s
  Read         14.88M    15.7/s
  Updated      50.10k     0.1/s

connected from address ec2-54-196-13-210.compute-1.amazonaws.com (54.196.13.210:44967)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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