tuesday 18 decembre 2018   -   20 : 57 : 03  
lang fr


Mysql status

MySQL 5.5.60-0+deb7u1-l  uptime 35 20:27:58     Tue Dec 18 20:50:01 2018

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current     119.92M            %Usage:  93.69
Write ratio     0.572
Read ratio      0.001

__ Questions ___________________________________________________________
Total          64.01M    20.7/s
  QC Hits      28.23M     9.1/s  %Total:  44.10
  DMS          27.21M     8.8/s           42.51
  Com_         18.41M     5.9/s           28.76
  -Unknown     11.79M     3.8/s           18.42
  COM_QUIT      1.95M     0.6/s            3.05
Slow               21     0.0/s            0.00  %DMS:   0.00
DMS            27.21M     8.8/s           42.51
  SELECT       19.67M     6.3/s           30.73         72.29
  UPDATE        4.33M     1.4/s            6.76         15.91
  INSERT        1.36M     0.4/s            2.13          5.01
  DELETE        1.32M     0.4/s            2.07          4.86
  REPLACE     523.61k     0.2/s            0.82          1.92
Com_           18.41M     5.9/s           28.76
  admin_comma  11.79M     3.8/s           18.41
  set_option    3.33M     1.1/s            5.21
  change_db     3.10M     1.0/s            4.84

__ SELECT and Sort _____________________________________________________
Scan            1.99M     0.6/s %SELECT:  10.11
Range           3.43M     1.1/s           17.45
Full join      20.21k     0.0/s            0.10
Range check         0       0/s            0.00
Full rng join       6     0.0/s            0.00
Sort scan       1.16M     0.4/s
Sort range      1.68M     0.5/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   50.98M of  64.00M  %Used:  79.66
Block Fragmnt  16.68%
Hits           28.23M     9.1/s
Inserts        17.98M     5.8/s
Insrt:Prune    3.17:1     4.0/s
Hit:Insert     1.57:1

__ Table Locks _________________________________________________________
Waited         37.69k     0.0/s  %Total:   0.13
Immediate      28.89M     9.3/s

__ Tables ______________________________________________________________
Open            1.01k of         %Cache: 100700
Opened         19.77k     0.0/s

__ Connections _________________________________________________________
Max used           28 of  200      %Max:  14.00
Total           1.95M     0.6/s

__ Created Temp ________________________________________________________
Disk table     95.56k     0.0/s
Table         729.35k     0.2/s
File               12     0.0/s

__ Threads _____________________________________________________________
Running             1 of    5
Cached             23 of   64      %Hit:    100
Created            28     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients            74     0.0/s
Connects          452     0.0/s

__ Bytes _______________________________________________________________
Sent          209.03G   67.5k/s
Received       10.06G    3.2k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         128.00M of 128.00M  %Used: 100.00
Read ratio      0.000
Pages
  Free              0            %Total:   0.00
  Data          8.10k                     98.88 %Drty:   0.12
  Misc             92                      1.12
  Latched                                  0.00
Reads         105.82M    34.2/s
  From file     6.15k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          5.01M     1.6/s
Flushes         1.01M     0.3/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         6.98k     0.0/s
  Writes        1.44M     0.5/s
  fsync       475.49k     0.2/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       8.15k     0.0/s
  Read          6.97k     0.0/s
  Written       1.01M     0.3/s

Rows
  Deleted     220.85k     0.1/s
  Inserted    186.51k     0.1/s
  Read         68.94M    22.3/s
  Updated     156.33k     0.1/s

connected from address ec2-54-90-109-231.compute-1.amazonaws.com (54.90.109.231:41458)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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