jeudi 19 juillet 2018   -   15 : 05 : 27  
lang en


Mysql status

MySQL 5.5.60-0+deb7u1-l  uptime 36 6:17:44      Thu Jul 19 15:00:01 2018

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current     126.31M            %Usage:  98.68
Write ratio     0.600
Read ratio      0.002

__ Questions ___________________________________________________________
Total          68.98M    22.0/s
  Com_         52.10M    16.6/s  %Total:  75.53
  -Unknown     47.15M    15.0/s           68.35
  DMS          38.75M    12.4/s           56.18
  QC Hits      23.80M     7.6/s           34.50
  COM_QUIT      1.48M     0.5/s            2.14
Slow               71     0.0/s            0.00  %DMS:   0.00
DMS            38.75M    12.4/s           56.18
  SELECT       33.18M    10.6/s           48.10         85.61
  UPDATE        3.22M     1.0/s            4.67          8.31
  INSERT        1.03M     0.3/s            1.49          2.65
  DELETE      928.87k     0.3/s            1.35          2.40
  REPLACE     398.00k     0.1/s            0.58          1.03
Com_           52.10M    16.6/s           75.53
  admin_comma  47.15M    15.0/s           68.35
  set_option    2.60M     0.8/s            3.77
  change_db     2.24M     0.7/s            3.25

__ SELECT and Sort _____________________________________________________
Scan            2.32M     0.7/s %SELECT:   7.00
Range           2.37M     0.8/s            7.14
Full join      15.74k     0.0/s            0.05
Range check         0       0/s            0.00
Full rng join       8     0.0/s            0.00
Sort scan     898.15k     0.3/s
Sort range      1.29M     0.4/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   50.86M of  64.00M  %Used:  79.46
Block Fragmnt  17.06%
Hits           23.80M     7.6/s
Inserts        31.94M    10.2/s
Insrt:Prune    8.95:1     9.1/s
Hit:Insert     0.75:1

__ Table Locks _________________________________________________________
Waited          1.13k     0.0/s  %Total:   0.00
Immediate      39.30M    12.5/s

__ Tables ______________________________________________________________
Open            1.02k of         %Cache: 102400
Opened         21.24k     0.0/s

__ Connections _________________________________________________________
Max used           27 of  200      %Max:  13.50
Total           1.48M     0.5/s

__ Created Temp ________________________________________________________
Disk table     73.68k     0.0/s
Table         638.40k     0.2/s
File               11     0.0/s

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

__ Aborted _____________________________________________________________
Clients           217     0.0/s
Connects          346     0.0/s

__ Bytes _______________________________________________________________
Sent          158.82G   50.7k/s
Received       10.57G    3.4k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.97M of 127.98M  %Used:  99.99
Read ratio      0.000
Pages
  Free              1            %Total:   0.01
  Data          8.13k                     99.26 %Drty:   0.05
  Misc             60                      0.73
  Latched                                  0.00
Reads          93.17M    29.7/s
  From file     6.44k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          7.04M     2.2/s
Flushes         1.63M     0.5/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits              23     0.0/s
Current             0
Time acquiring
  Total          1370 ms
  Average          59 ms
  Max            1002 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         7.13k     0.0/s
  Writes        2.29M     0.7/s
  fsync       732.37k     0.2/s
  Pending
    Reads           0
    Writes          0
    fysnc           1

Pages
  Created      15.51k     0.0/s
  Read          7.12k     0.0/s
  Written       1.63M     0.5/s

Rows
  Deleted     285.37k     0.1/s
  Inserted    321.32k     0.1/s
  Read         51.91M    16.6/s
  Updated     211.35k     0.1/s

connected from address ec2-54-224-216-155.compute-1.amazonaws.com (54.224.216.155:38333)
using CCBot/2.0 (http://commoncrawl.org/faq/)

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