dimanche 21 avril 2019   -   07 : 06 : 17  
lang en


Mysql status

MySQL 5.5.60-0+deb7u1-l  uptime 41 10:5:50      Sun Apr 21 07:00:01 2019

__ Key _________________________________________________________________
Buffer used    22.21M of 128.00M  %Used:  17.35
  Current      30.39M            %Usage:  23.75
Write ratio     0.551
Read ratio      0.012

__ Questions ___________________________________________________________
Total          48.32M    13.5/s
  DMS          20.55M     5.7/s  %Total:  42.53
  QC Hits      17.37M     4.9/s           35.95
  Com_          9.73M     2.7/s           20.15
  COM_QUIT      1.65M     0.5/s            3.42
  -Unknown    990.85k     0.3/s            2.05
Slow              561     0.0/s            0.00  %DMS:   0.00
DMS            20.55M     5.7/s           42.53
  SELECT       15.68M     4.4/s           32.45         76.29
  UPDATE        2.79M     0.8/s            5.77         13.57
  INSERT        1.02M     0.3/s            2.11          4.95
  DELETE      792.37k     0.2/s            1.64          3.86
  REPLACE     272.92k     0.1/s            0.56          1.33
Com_            9.73M     2.7/s           20.15
  set_option    4.32M     1.2/s            8.95
  change_db     2.56M     0.7/s            5.30
  admin_comma 988.52k     0.3/s            2.05

__ SELECT and Sort _____________________________________________________
Scan            3.20M     0.9/s %SELECT:  20.40
Range           2.07M     0.6/s           13.19
Full join      16.38k     0.0/s            0.10
Range check         0       0/s            0.00
Full rng join       5     0.0/s            0.00
Sort scan       1.18M     0.3/s
Sort range      1.38M     0.4/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   49.50M of  64.00M  %Used:  77.35
Block Fragmnt  15.33%
Hits           17.37M     4.9/s
Inserts        13.74M     3.8/s
Insrt:Prune    3.47:1     2.7/s
Hit:Insert     1.26:1

__ Table Locks _________________________________________________________
Waited         21.77k     0.0/s  %Total:   0.10
Immediate      22.14M     6.2/s

__ Tables ______________________________________________________________
Open            1.02k of         %Cache: 102400
Opened        853.42k     0.2/s

__ Connections _________________________________________________________
Max used           38 of  200      %Max:  19.00
Total           1.66M     0.5/s

__ Created Temp ________________________________________________________
Disk table    946.68k     0.3/s
Table           1.83M     0.5/s
File               12     0.0/s

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

__ Aborted _____________________________________________________________
Clients           394     0.0/s
Connects          313     0.0/s

__ Bytes _______________________________________________________________
Sent          313.10G   87.5k/s
Received        7.81G    2.2k/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.10k                     98.93 %Drty:   0.00
  Misc             87                      1.06
  Latched                                  0.00
Reads          89.77M    25.1/s
  From file     7.82k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          3.66M     1.0/s
Flushes       785.37k     0.2/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         8.27k     0.0/s
  Writes        1.10M     0.3/s
  fsync       349.11k     0.1/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       8.38k     0.0/s
  Read          8.25k     0.0/s
  Written     785.37k     0.2/s

Rows
  Deleted     156.38k     0.0/s
  Inserted    136.84k     0.0/s
  Read         58.85M    16.4/s
  Updated     127.91k     0.0/s

connected from address ec2-18-234-111-56.compute-1.amazonaws.com (18.234.111.56:43436)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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