tuesday 25 septembre 2018   -   11 : 44 : 31  
lang fr


Mysql status

MySQL 5.5.60-0+deb7u1-l  uptime 0 19:20:36      Tue Sep 25 11:40:01 2018

__ Key _________________________________________________________________
Buffer used    12.85M of 128.00M  %Used:  10.04
  Current      36.19M            %Usage:  28.27
Write ratio     0.603
Read ratio      0.004

__ Questions ___________________________________________________________
Total           1.17M    16.8/s
  Com_        778.09k    11.2/s  %Total:  66.39
  -Unknown    681.87k     9.8/s           58.18
  DMS         620.65k     8.9/s           52.95
  QC Hits     424.85k     6.1/s           36.25
  COM_QUIT     30.35k     0.4/s            2.59
Slow                0       0/s            0.00  %DMS:   0.00
DMS           620.65k     8.9/s           52.95
  SELECT      518.57k     7.4/s           44.24         83.55
  UPDATE       54.50k     0.8/s            4.65          8.78
  INSERT       24.27k     0.3/s            2.07          3.91
  DELETE       16.61k     0.2/s            1.42          2.68
  REPLACE       6.70k     0.1/s            0.57          1.08
Com_          778.09k    11.2/s           66.39
  admin_comma 681.80k     9.8/s           58.17
  set_option   52.73k     0.8/s            4.50
  change_db    40.80k     0.6/s            3.48

__ SELECT and Sort _____________________________________________________
Scan           43.05k     0.6/s %SELECT:   8.30
Range          50.45k     0.7/s            9.73
Full join         542     0.0/s            0.10
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan      23.48k     0.3/s
Sort range     22.77k     0.3/s
Sort mrg pass       0       0/s

__ Query Cache _________________________________________________________
Memory usage   56.58M of  64.00M  %Used:  88.41
Block Fragmnt  12.26%
Hits          424.85k     6.1/s
Inserts       493.74k     7.1/s
Insrt:Prune    9.11:1     6.3/s
Hit:Insert     0.86:1

__ Table Locks _________________________________________________________
Waited             22     0.0/s  %Total:   0.00
Immediate     627.69k     9.0/s

__ Tables ______________________________________________________________
Open              690 of         %Cache: 69000.
Opened            844     0.0/s

__ Connections _________________________________________________________
Max used           10 of  200      %Max:   5.00
Total          30.36k     0.4/s

__ Created Temp ________________________________________________________
Disk table      2.25k     0.0/s
Table          17.01k     0.2/s
File                7     0.0/s

__ Threads _____________________________________________________________
Running             1 of    1
Cached              9 of   64      %Hit:  99.97
Created            10     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients             0       0/s
Connects            5     0.0/s

__ Bytes _______________________________________________________________
Sent            4.59G   65.9k/s
Received      173.24M    2.5k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          34.53M of 127.98M  %Used:  26.98
Read ratio      0.001
Pages
  Free          5.98k            %Total:  73.02
  Data          2.18k                     26.64 %Drty:   0.00
  Misc             28                      0.34
  Latched                                  0.00
Reads           1.90M    27.3/s
  From file     1.84k     0.0/s            0.10
  Ahead Rnd         0       0/s
  Ahead Sql                 0/s
Writes        111.44k     1.6/s
Flushes        25.95k     0.4/s
Wait Free           0       0/s

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

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         1.88k     0.0/s
  Writes       37.59k     0.5/s
  fsync        13.32k     0.2/s
  Pending
    Reads           0
    Writes          0
    fysnc           0

Pages
  Created         316     0.0/s
  Read          1.87k     0.0/s
  Written      25.95k     0.4/s

Rows
  Deleted       4.71k     0.1/s
  Inserted      6.34k     0.1/s
  Read        981.93k    14.1/s
  Updated       2.15k     0.0/s

connected from address ec2-54-162-239-233.compute-1.amazonaws.com (54.162.239.233:58367)
using CCBot/2.0 (https://commoncrawl.org/faq/)

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