dimanche 22 avril 2018   -   04 : 31 : 14  
lang en


Mysql status

MySQL 5.5.59-0+deb7u1-l  uptime 19 7:0:25       Sun Apr 22 04:30:01 2018

__ Key _________________________________________________________________
Buffer used    37.57M of 128.00M  %Used:  29.35
  Current      60.91M            %Usage:  47.58
Write ratio     0.548
Read ratio      0.001

__ Questions ___________________________________________________________
Total          34.80M    20.9/s
  QC Hits      17.66M    10.6/s  %Total:  50.73
  DMS          12.33M     7.4/s           35.42
  Com_          4.16M     2.5/s           11.95
  COM_QUIT      1.06M     0.6/s            3.03
  -Unknown    393.96k     0.2/s            1.13
Slow               25     0.0/s            0.00  %DMS:   0.00
DMS            12.33M     7.4/s           35.42
  SELECT        7.65M     4.6/s           21.97         62.03
  UPDATE        2.70M     1.6/s            7.76         21.92
  INSERT      906.50k     0.5/s            2.60          7.35
  DELETE      783.54k     0.5/s            2.25          6.36
  REPLACE     288.34k     0.2/s            0.83          2.34
Com_            4.16M     2.5/s           11.95
  change_db     1.85M     1.1/s            5.32
  set_option    1.80M     1.1/s            5.17
  admin_comma 392.98k     0.2/s            1.13

__ SELECT and Sort _____________________________________________________
Scan            1.00M     0.6/s %SELECT:  13.12
Range           1.83M     1.1/s           23.98
Full join      11.92k     0.0/s            0.16
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     455.15k     0.3/s
Sort range    817.51k     0.5/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   50.64M of  64.00M  %Used:  79.12
Block Fragmnt  15.32%
Hits           17.66M    10.6/s
Inserts         6.79M     4.1/s
Insrt:Prune    2.50:1     2.4/s
Hit:Insert     2.60:1

__ Table Locks _________________________________________________________
Waited          3.06k     0.0/s  %Total:   0.02
Immediate      14.44M     8.7/s

__ Tables ______________________________________________________________
Open            1.00k of         %Cache: 100300
Opened         26.86k     0.0/s

__ Connections _________________________________________________________
Max used           29 of  200      %Max:  14.50
Total           1.06M     0.6/s

__ Created Temp ________________________________________________________
Disk table     79.54k     0.0/s
Table         297.53k     0.2/s
File               13     0.0/s

__ Threads _____________________________________________________________
Running             3 of    7
Cached             22 of   64      %Hit:    100
Created            29     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients             2     0.0/s
Connects          168     0.0/s

__ Bytes _______________________________________________________________
Sent          105.68G   63.4k/s
Received        6.16G    3.7k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.94M of 127.98M  %Used:  99.96
Read ratio      0.000
Pages
  Free              3            %Total:   0.04
  Data          8.12k                     99.13 %Drty:   0.05
  Misc             68                      0.83
  Latched                                  0.00
Reads          67.11M    40.3/s
  From file     7.49k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          4.69M     2.8/s
Flushes         1.16M     0.7/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits              20     0.0/s
Current             0
Time acquiring
  Total          1910 ms
  Average          95 ms
  Max            1904 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         8.00k     0.0/s
  Writes        1.62M     1.0/s
  fsync       511.54k     0.3/s
  Pending
    Reads           0
    Writes          0
    fysnc           1

Pages
  Created      16.02k     0.0/s
  Read          7.99k     0.0/s
  Written       1.16M     0.7/s

Rows
  Deleted     180.92k     0.1/s
  Inserted    183.15k     0.1/s
  Read         40.06M    24.0/s
  Updated     185.71k     0.1/s

connected from address ec2-54-196-47-145.compute-1.amazonaws.com (54.196.47.145:40297)
using CCBot/2.0 (http://commoncrawl.org/faq/)

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