thirsday 27 july 2017   -   04 : 30 : 48  
lang fr


Mysql status

MySQL 5.5.55-0+deb7u1-l  uptime 28 1:55:47      Thu Jul 27 04:30:02 2017

__ Key _________________________________________________________________
Buffer used    86.54M of 128.00M  %Used:  67.61
  Current      96.37M            %Usage:  75.29
Write ratio     0.410
Read ratio      0.001

__ Questions ___________________________________________________________
Total          62.20M    25.6/s
  DMS          42.39M    17.5/s  %Total:  68.14
  Com_         26.81M    11.0/s           43.10
  -Unknown     23.90M     9.9/s           38.42
  QC Hits      15.73M     6.5/s           25.28
  COM_QUIT      1.18M     0.5/s            1.90
Slow              151     0.0/s            0.00  %DMS:   0.00
DMS            42.39M    17.5/s           68.14
  INSERT       20.67M     8.5/s           33.24         48.77
  SELECT       18.38M     7.6/s           29.55         43.36
  UPDATE        2.76M     1.1/s            4.43          6.50
  DELETE      487.22k     0.2/s            0.78          1.15
  REPLACE      88.97k     0.0/s            0.14          0.21
Com_           26.81M    11.0/s           43.10
  admin_comma  23.90M     9.8/s           38.42
  set_option    1.99M     0.8/s            3.20
  change_db   862.36k     0.4/s            1.39

__ SELECT and Sort _____________________________________________________
Scan            1.28M     0.5/s %SELECT:   6.97
Range         900.04k     0.4/s            4.90
Full join      10.05k     0.0/s            0.05
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan     496.11k     0.2/s
Sort range      1.27M     0.5/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   51.86M of  64.00M  %Used:  81.02
Block Fragmnt  11.82%
Hits           15.73M     6.5/s
Inserts        17.93M     7.4/s
Insrt:Prune    5.42:1     6.0/s
Hit:Insert     0.88:1

__ Table Locks _________________________________________________________
Waited          1.20k     0.0/s  %Total:   0.00
Immediate      43.96M    18.1/s

__ Tables ______________________________________________________________
Open            1.01k of         %Cache: 101100
Opened         30.17k     0.0/s

__ Connections _________________________________________________________
Max used           53 of  200      %Max:  26.50
Total           1.18M     0.5/s

__ Created Temp ________________________________________________________
Disk table     89.04k     0.0/s
Table         318.37k     0.1/s
File               16     0.0/s

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

__ Aborted _____________________________________________________________
Clients         2.79k     0.0/s
Connects          123     0.0/s

__ Bytes _______________________________________________________________
Sent          106.88G   44.1k/s
Received       16.59G    6.8k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         127.97M of 128.00M  %Used:  99.98
Read ratio      0.000
Pages
  Free              2            %Total:   0.02
  Data          8.12k                     99.10 %Drty:   0.70
  Misc             72                      0.88
  Latched                                  0.00
Reads          82.56M    34.0/s
  From file     5.91k     0.0/s            0.01
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes         17.18M     7.1/s
Flushes         5.91M     2.4/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         6.23k     0.0/s
  Writes        7.92M     3.3/s
  fsync         2.22M     0.9/s
  Pending
    Reads           0
    Writes          0
    fysnc           1

Pages
  Created       7.70k     0.0/s
  Read          6.22k     0.0/s
  Written       5.91M     2.4/s

Rows
  Deleted     150.09k     0.1/s
  Inserted    148.38k     0.1/s
  Read         23.97M     9.9/s
  Updated       1.43M     0.6/s

connected from address ec2-54-158-25-146.compute-1.amazonaws.com (54.158.25.146:41761)
using CCBot/2.0 (http://commoncrawl.org/faq/)

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