saturday 21 april 2018   -   23 : 20 : 34  
lang fr


Mysql status

MySQL 5.5.59-0+deb7u1-l  uptime 19 1:50:25      Sat Apr 21 23:20:01 2018

__ Key _________________________________________________________________
Buffer used    37.40M of 128.00M  %Used:  29.22
  Current      60.71M            %Usage:  47.43
Write ratio     0.547
Read ratio      0.001

__ Questions ___________________________________________________________
Total          34.40M    20.9/s
  QC Hits      17.46M    10.6/s  %Total:  50.76
  DMS          12.20M     7.4/s           35.48
  Com_          4.09M     2.5/s           11.88
  COM_QUIT      1.04M     0.6/s            3.01
  -Unknown    388.40k     0.2/s            1.13
Slow               25     0.0/s            0.00  %DMS:   0.00
DMS            12.20M     7.4/s           35.48
  SELECT        7.57M     4.6/s           22.01         62.04
  UPDATE        2.68M     1.6/s            7.78         21.94
  INSERT      895.00k     0.5/s            2.60          7.33
  DELETE      775.02k     0.5/s            2.25          6.35
  REPLACE     285.05k     0.2/s            0.83          2.34
Com_            4.09M     2.5/s           11.88
  change_db     1.82M     1.1/s            5.29
  set_option    1.76M     1.1/s            5.13
  admin_comma 387.44k     0.2/s            1.13

__ SELECT and Sort _____________________________________________________
Scan          989.58k     0.6/s %SELECT:  13.07
Range           1.82M     1.1/s           23.99
Full join      11.86k     0.0/s            0.16
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     446.70k     0.3/s
Sort range    809.51k     0.5/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   51.32M of  64.00M  %Used:  80.19
Block Fragmnt  13.53%
Hits           17.46M    10.6/s
Inserts         6.73M     4.1/s
Insrt:Prune    2.51:1     2.5/s
Hit:Insert     2.60:1

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

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

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

__ Created Temp ________________________________________________________
Disk table     78.25k     0.0/s
Table         294.14k     0.2/s
File               13     0.0/s

__ Threads _____________________________________________________________
Running             1 of    2
Cached             27 of   64      %Hit:    100
Created            29     0.0/s
Slow                0       0/s

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

__ Bytes _______________________________________________________________
Sent          104.69G   63.5k/s
Received        6.10G    3.7k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.89M of 127.98M  %Used:  99.93
Read ratio      0.000
Pages
  Free              6            %Total:   0.07
  Data          8.12k                     99.10 %Drty:   0.00
  Misc             68                      0.83
  Latched                                  0.00
Reads          66.03M    40.1/s
  From file     7.49k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          4.68M     2.8/s
Flushes         1.15M     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.61M     1.0/s
  fsync       509.55k     0.3/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created      16.01k     0.0/s
  Read          7.99k     0.0/s
  Written       1.15M     0.7/s

Rows
  Deleted     180.57k     0.1/s
  Inserted    182.54k     0.1/s
  Read         39.23M    23.8/s
  Updated     185.15k     0.1/s

connected from address ec2-54-81-166-196.compute-1.amazonaws.com (54.81.166.196:43571)
using CCBot/2.0 (http://commoncrawl.org/faq/)

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