jeudi 23 mars 2017   -   13 : 13 : 07  
lang en


Mysql status

MySQL 5.5.54-0+deb7u2-l  uptime 7 12:30:37      Thu Mar 23 13:10:02 2017

__ Key _________________________________________________________________
Buffer used    29.81M of 128.00M  %Used:  23.29
  Current      40.47M            %Usage:  31.62
Write ratio     0.554
Read ratio      0.002

__ Questions ___________________________________________________________
Total          12.76M    19.6/s
  Com_          7.87M    12.1/s  %Total:  61.67
  DMS           7.07M    10.9/s           55.43
  -Unknown      7.07M    10.9/s           55.40
  QC Hits       4.60M     7.1/s           36.07
  COM_QUIT    284.86k     0.4/s            2.23
Slow               73     0.0/s            0.00  %DMS:   0.00
DMS             7.07M    10.9/s           55.43
  SELECT        5.78M     8.9/s           45.27         81.68
  UPDATE      801.49k     1.2/s            6.28         11.33
  INSERT      270.80k     0.4/s            2.12          3.83
  DELETE      177.99k     0.3/s            1.39          2.52
  REPLACE      45.49k     0.1/s            0.36          0.64
Com_            7.87M    12.1/s           61.67
  admin_comma   7.07M    10.9/s           55.39
  set_option  409.31k     0.6/s            3.21
  change_db   373.45k     0.6/s            2.93

__ SELECT and Sort _____________________________________________________
Scan          415.40k     0.6/s %SELECT:   7.19
Range         379.51k     0.6/s            6.57
Full join       3.11k     0.0/s            0.05
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan      98.42k     0.2/s
Sort range    278.57k     0.4/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   52.53M of  64.00M  %Used:  82.07
Block Fragmnt  12.58%
Hits            4.60M     7.1/s
Inserts         5.67M     8.7/s
Insrt:Prune    4.82:1     6.9/s
Hit:Insert     0.81:1

__ Table Locks _________________________________________________________
Waited            458     0.0/s  %Total:   0.01
Immediate       8.17M    12.6/s

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

__ Connections _________________________________________________________
Max used           22 of  200      %Max:  11.00
Total         285.27k     0.4/s

__ Created Temp ________________________________________________________
Disk table     26.86k     0.0/s
Table         100.26k     0.2/s
File                8     0.0/s

__ Threads _____________________________________________________________
Running             1 of    4
Cached             18 of   64      %Hit:  99.99
Created            22     0.0/s
Slow                0       0/s

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

__ Bytes _______________________________________________________________
Sent           33.68G   51.8k/s
Received        2.54G    3.9k/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.50 %Drty:   0.00
  Misc             41                      0.50
  Latched                                  0.00
Reads          17.77M    27.3/s
  From file     3.06k     0.0/s            0.02
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes          1.75M     2.7/s
Flushes       465.74k     0.7/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         3.14k     0.0/s
  Writes      674.76k     1.0/s
  fsync       226.35k     0.3/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created       6.35k     0.0/s
  Read          3.13k     0.0/s
  Written     465.74k     0.7/s

Rows
  Deleted      48.89k     0.1/s
  Inserted     62.29k     0.1/s
  Read          8.33M    12.8/s
  Updated     115.02k     0.2/s

connected from address ec2-54-166-77-32.compute-1.amazonaws.com (54.166.77.32:58876)
using CCBot/2.0 (http://commoncrawl.org/faq/)

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