jeudi 17 janvier 2019   -   04 : 47 : 38  
lang en


Mysql status

MySQL 5.5.60-0+deb7u1-l  uptime 28 10:22:1      Thu Jan 17 04:40:01 2019

__ Key _________________________________________________________________
Buffer used   104.66M of 128.00M  %Used:  81.76
  Current     128.00M            %Usage: 100.00
Write ratio     0.247
Read ratio      0.001

__ Questions ___________________________________________________________
Total          48.10M    19.6/s
  QC Hits      22.67M     9.2/s  %Total:  47.13
  DMS          17.92M     7.3/s           37.26
  Com_         11.16M     4.5/s           23.20
  -Unknown      5.52M     2.2/s           11.47
  COM_QUIT      1.87M     0.8/s            3.88
Slow               13     0.0/s            0.00  %DMS:   0.00
DMS            17.92M     7.3/s           37.26
  SELECT       12.39M     5.0/s           25.77         69.16
  UPDATE        3.33M     1.4/s            6.92         18.58
  DELETE      907.21k     0.4/s            1.89          5.06
  INSERT      867.51k     0.4/s            1.80          4.84
  REPLACE     422.72k     0.2/s            0.88          2.36
Com_           11.16M     4.5/s           23.20
  admin_comma   5.52M     2.2/s           11.47
  set_option    2.75M     1.1/s            5.72
  change_db     2.74M     1.1/s            5.71

__ SELECT and Sort _____________________________________________________
Scan            1.36M     0.6/s %SELECT:  10.94
Range           2.64M     1.1/s           21.33
Full join      32.56k     0.0/s            0.26
Range check         0       0/s            0.00
Full rng join      53     0.0/s            0.00
Sort scan     932.28k     0.4/s
Sort range      1.39M     0.6/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   50.81M of  64.00M  %Used:  79.39
Block Fragmnt  17.27%
Hits           22.67M     9.2/s
Inserts        11.09M     4.5/s
Insrt:Prune    2.98:1     3.0/s
Hit:Insert     2.05:1

__ Table Locks _________________________________________________________
Waited          9.68k     0.0/s  %Total:   0.05
Immediate      19.00M     7.7/s

__ Tables ______________________________________________________________
Open            1.02k of         %Cache: 102300
Opened         20.54k     0.0/s

__ Connections _________________________________________________________
Max used           24 of  200      %Max:  12.00
Total           1.87M     0.8/s

__ Created Temp ________________________________________________________
Disk table     81.82k     0.0/s
Table         565.40k     0.2/s
File               10     0.0/s

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

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

__ Bytes _______________________________________________________________
Sent          127.82G   52.0k/s
Received        7.44G    3.0k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.98M of 128.00M  %Used:  99.99
Read ratio      0.000
Pages
  Free              1            %Total:   0.01
  Data          8.13k                     99.26 %Drty:   0.00
  Misc             60                      0.73
  Latched                                  0.00
Reads          80.98M    33.0/s
  From file     5.17k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          3.86M     1.6/s
Flushes       863.01k     0.4/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         5.55k     0.0/s
  Writes        1.27M     0.5/s
  fsync       435.32k     0.2/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       7.75k     0.0/s
  Read          5.41k     0.0/s
  Written     863.01k     0.4/s

Rows
  Deleted     136.00k     0.1/s
  Inserted    140.58k     0.1/s
  Read         50.20M    20.4/s
  Updated     205.90k     0.1/s

connected from address ec2-18-212-92-235.compute-1.amazonaws.com (18.212.92.235:43951)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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