samedi 23 juin 2018   -   21 : 18 : 58  
lang en


Mysql status

MySQL 5.5.60-0+deb7u1-l  uptime 10 12:27:44     Sat Jun 23 21:10:01 2018

__ Key _________________________________________________________________
Buffer used    56.57M of 128.00M  %Used:  44.19
  Current      79.91M            %Usage:  62.43
Write ratio     0.603
Read ratio      0.001

__ Questions ___________________________________________________________
Total          26.98M    29.7/s
  Com_         19.70M    21.7/s  %Total:  73.00
  -Unknown     17.76M    19.5/s           65.84
  DMS          14.91M    16.4/s           55.24
  QC Hits       9.57M    10.5/s           35.47
  COM_QUIT    575.00k     0.6/s            2.13
Slow               19     0.0/s            0.00  %DMS:   0.00
DMS            14.91M    16.4/s           55.24
  SELECT       12.73M    14.0/s           47.17         85.38
  UPDATE        1.26M     1.4/s            4.67          8.45
  INSERT      387.23k     0.4/s            1.44          2.60
  DELETE      376.66k     0.4/s            1.40          2.53
  REPLACE     155.67k     0.2/s            0.58          1.04
Com_           19.70M    21.7/s           73.00
  admin_comma  17.76M    19.5/s           65.84
  set_option    1.01M     1.1/s            3.75
  change_db   880.56k     1.0/s            3.26

__ SELECT and Sort _____________________________________________________
Scan          890.41k     1.0/s %SELECT:   7.00
Range         970.50k     1.1/s            7.63
Full join       8.28k     0.0/s            0.07
Range check         0       0/s            0.00
Full rng join       8     0.0/s            0.00
Sort scan     329.62k     0.4/s
Sort range    533.34k     0.6/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   52.88M of  64.00M  %Used:  82.62
Block Fragmnt  13.04%
Hits            9.57M    10.5/s
Inserts        12.24M    13.5/s
Insrt:Prune    8.94:1    12.0/s
Hit:Insert     0.78:1

__ Table Locks _________________________________________________________
Waited            358     0.0/s  %Total:   0.00
Immediate      15.25M    16.8/s

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

__ Connections _________________________________________________________
Max used           16 of  200      %Max:   8.00
Total         575.07k     0.6/s

__ Created Temp ________________________________________________________
Disk table     23.37k     0.0/s
Table         224.35k     0.2/s
File                8     0.0/s

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

__ Aborted _____________________________________________________________
Clients           130     0.0/s
Connects           69     0.0/s

__ Bytes _______________________________________________________________
Sent           57.47G   63.2k/s
Received        4.19G    4.6k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.98M of 127.98M  %Used: 100.00
Read ratio      0.000
Pages
  Free              0            %Total:   0.00
  Data          8.15k                     99.56 %Drty:   0.05
  Misc             36                      0.44
  Latched                                  0.00
Reads          30.69M    33.8/s
  From file     5.48k     0.0/s            0.02
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          2.34M     2.6/s
Flushes       659.53k     0.7/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         6.17k     0.0/s
  Writes      914.79k     1.0/s
  fsync       283.46k     0.3/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created      10.99k     0.0/s
  Read          6.15k     0.0/s
  Written     659.53k     0.7/s

Rows
  Deleted      80.91k     0.1/s
  Inserted    120.51k     0.1/s
  Read         16.14M    17.8/s
  Updated      83.69k     0.1/s

connected from address ec2-54-224-85-115.compute-1.amazonaws.com (54.224.85.115:33575)
using CCBot/2.0 (http://commoncrawl.org/faq/)

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