mardi 23 janvier 2018   -   16 : 25 : 55  
lang en


Mysql status

MySQL 5.5.58-0+deb7u1-l  uptime 12 18:47:15     Tue Jan 23 16:20:01 2018

__ Key _________________________________________________________________
Buffer used    30.85M of 128.00M  %Used:  24.11
  Current      41.41M            %Usage:  32.35
Write ratio     0.660
Read ratio      0.004

__ Questions ___________________________________________________________
Total          23.81M    21.6/s
  QC Hits      14.73M    13.3/s  %Total:  61.87
  DMS           6.80M     6.2/s           28.55
  Com_          2.27M     2.1/s            9.52
  COM_QUIT    513.23k     0.5/s            2.16
  -Unknown    499.77k     0.5/s            2.10
Slow               16     0.0/s            0.00  %DMS:   0.00
DMS             6.80M     6.2/s           28.55
  SELECT        4.57M     4.1/s           19.18         67.18
  UPDATE        1.27M     1.2/s            5.34         18.70
  INSERT      428.21k     0.4/s            1.80          6.30
  DELETE      403.52k     0.4/s            1.69          5.93
  REPLACE     128.40k     0.1/s            0.54          1.89
Com_            2.27M     2.1/s            9.52
  set_option  878.39k     0.8/s            3.69
  change_db   853.34k     0.8/s            3.58
  admin_comma 499.47k     0.5/s            2.10

__ SELECT and Sort _____________________________________________________
Scan          619.68k     0.6/s %SELECT:  13.57
Range         901.79k     0.8/s           19.74
Full join       4.30k     0.0/s            0.09
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     336.20k     0.3/s
Sort range    991.02k     0.9/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   54.13M of  64.00M  %Used:  84.59
Block Fragmnt  11.47%
Hits           14.73M    13.3/s
Inserts         4.18M     3.8/s
Insrt:Prune       2:1     1.9/s
Hit:Insert     3.52:1

__ Table Locks _________________________________________________________
Waited          1.16k     0.0/s  %Total:   0.01
Immediate       8.15M     7.4/s

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

__ Connections _________________________________________________________
Max used           53 of  200      %Max:  26.50
Total         513.27k     0.5/s

__ Created Temp ________________________________________________________
Disk table     61.20k     0.1/s
Table         165.29k     0.1/s
File               11     0.0/s

__ Threads _____________________________________________________________
Running             1 of    1
Cached             52 of   64      %Hit:  99.99
Created            53     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients            75     0.0/s
Connects           50     0.0/s

__ Bytes _______________________________________________________________
Sent           59.96G   54.3k/s
Received        5.08G    4.6k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         112.08M of 127.98M  %Used:  87.57
Read ratio      0.000
Pages
  Free          1.02k            %Total:  12.43
  Data          7.10k                     86.69 %Drty:   0.00
  Misc             72                      0.88
  Latched                                  0.00
Reads          24.72M    22.4/s
  From file     4.36k     0.0/s            0.02
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          1.61M     1.5/s
Flushes       408.73k     0.4/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         4.55k     0.0/s
  Writes      597.18k     0.5/s
  fsync       204.30k     0.2/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       2.56k     0.0/s
  Read          4.54k     0.0/s
  Written     408.73k     0.4/s

Rows
  Deleted      54.13k     0.0/s
  Inserted     50.49k     0.0/s
  Read         13.25M    12.0/s
  Updated     110.35k     0.1/s

connected from address ec2-54-163-39-19.compute-1.amazonaws.com (54.163.39.19:48056)
using CCBot/2.0 (http://commoncrawl.org/faq/)

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