thirsday 19 july 2018   -   09 : 14 : 11  
lang fr


Mysql status

MySQL 5.5.60-0+deb7u1-l  uptime 36 0:27:44      Thu Jul 19 09:10:01 2018

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

__ Questions ___________________________________________________________
Total          68.71M    22.1/s
  Com_         51.87M    16.7/s  %Total:  75.49
  -Unknown     46.95M    15.1/s           68.32
  DMS          38.59M    12.4/s           56.17
  QC Hits      23.72M     7.6/s           34.52
  COM_QUIT      1.47M     0.5/s            2.14
Slow               71     0.0/s            0.00  %DMS:   0.00
DMS            38.59M    12.4/s           56.17
  SELECT       33.04M    10.6/s           48.08         85.61
  UPDATE        3.21M     1.0/s            4.67          8.32
  INSERT        1.02M     0.3/s            1.49          2.65
  DELETE      925.41k     0.3/s            1.35          2.40
  REPLACE     396.43k     0.1/s            0.58          1.03
Com_           51.87M    16.7/s           75.49
  admin_comma  46.94M    15.1/s           68.32
  set_option    2.59M     0.8/s            3.77
  change_db     2.24M     0.7/s            3.25

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

__ Query Cache _________________________________________________________
Memory usage   51.29M of  64.00M  %Used:  80.13
Block Fragmnt  15.64%
Hits           23.72M     7.6/s
Inserts        31.81M    10.2/s
Insrt:Prune    8.94:1     9.1/s
Hit:Insert     0.75:1

__ Table Locks _________________________________________________________
Waited          1.13k     0.0/s  %Total:   0.00
Immediate      39.14M    12.6/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.47M     0.5/s

__ Created Temp ________________________________________________________
Disk table     73.41k     0.0/s
Table         635.42k     0.2/s
File               11     0.0/s

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

__ Aborted _____________________________________________________________
Clients           216     0.0/s
Connects          345     0.0/s

__ Bytes _______________________________________________________________
Sent          158.14G   50.8k/s
Received       10.53G    3.4k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.84M of 127.98M  %Used:  99.89
Read ratio      0.000
Pages
  Free              9            %Total:   0.11
  Data          8.12k                     99.15 %Drty:   0.00
  Misc             61                      0.74
  Latched                                  0.00
Reads          92.78M    29.8/s
  From file     6.42k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          7.01M     2.3/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.11k     0.0/s
  Writes        2.28M     0.7/s
  fsync       729.81k     0.2/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

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

Rows
  Deleted     283.74k     0.1/s
  Inserted    320.25k     0.1/s
  Read         51.70M    16.6/s
  Updated     210.76k     0.1/s

connected from address ec2-54-80-7-173.compute-1.amazonaws.com (54.80.7.173:57607)
using CCBot/2.0 (http://commoncrawl.org/faq/)

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