|
Mysql status
MySQL 5.5.62-0+deb8u1-l uptime 42 7:10:4 Fri Jan 10 18:50:01 2020
__ Key _________________________________________________________________
Buffer used 18.07M of 128.00M %Used: 14.12
Current 25.36M %Usage: 19.81
Write ratio 0.522
Read ratio 0.008
__ Questions ___________________________________________________________
Total 101.75M 27.8/s
QC Hits 47.91M 13.1/s %Total: 47.09
DMS 34.38M 9.4/s 33.79
Com_ 16.14M 4.4/s 15.86
COM_QUIT 3.31M 0.9/s 3.26
+Unknown 5.73k 0.0/s 0.01
Slow 8.59k 0.0/s 0.01 %DMS: 0.02
DMS 34.38M 9.4/s 33.79
SELECT 21.38M 5.9/s 21.01 62.18
UPDATE 8.28M 2.3/s 8.14 24.09
DELETE 2.13M 0.6/s 2.09 6.19
INSERT 1.49M 0.4/s 1.47 4.34
REPLACE 1.10M 0.3/s 1.08 3.20
Com_ 16.14M 4.4/s 15.86
set_option 7.24M 2.0/s 7.11
change_db 6.63M 1.8/s 6.52
show_fields 429.30k 0.1/s 0.42
__ SELECT and Sort _____________________________________________________
Scan 4.75M 1.3/s %SELECT: 22.20
Range 3.69M 1.0/s 17.28
Full join 67.32k 0.0/s 0.31
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 2.36M 0.6/s
Sort range 1.67M 0.5/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 30.75M of 64.00M %Used: 48.04
Block Fragmnt 0.06%
Hits 47.91M 13.1/s
Inserts 16.84M 4.6/s
Insrt:Prune 10.17:1 4.2/s
Hit:Insert 2.85:1
__ Table Locks _________________________________________________________
Waited 17.73k 0.0/s %Total: 0.05
Immediate 34.50M 9.4/s
__ Tables ______________________________________________________________
Open 330 of %Cache: 33000.
Opened 1.09M 0.3/s
__ Connections _________________________________________________________
Max used 62 of 200 %Max: 31.00
Total 3.31M 0.9/s
__ Created Temp ________________________________________________________
Disk table 1.06M 0.3/s
Table 2.04M 0.6/s
File 13 0.0/s
__ Threads _____________________________________________________________
Running 1 of 2
Cached 60 of 64 %Hit: 100
Created 62 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 645 0.0/s
Connects 162 0.0/s
__ Bytes _______________________________________________________________
Sent 340.45G 93.2k/s
Received 16.35G 4.5k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 127.95M of 127.98M %Used: 99.98
Read ratio 0.000
Pages
Free 2 %Total: 0.02
Data 8.15k 99.52 %Drty: 0.00
Misc 37 0.45
Latched 0.00
Reads 120.53M 33.0/s
From file 10.32k 0.0/s 0.01
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 5.21M 1.4/s
Flushes 1.07M 0.3/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 9 0.0/s
Current 0
Time acquiring
Total 195 ms
Average 21 ms
Max 102 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 10.49k 0.0/s
Writes 1.51M 0.4/s
fsync 485.71k 0.1/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 8.62k 0.0/s
Read 10.48k 0.0/s
Written 1.07M 0.3/s
Rows
Deleted 211.97k 0.1/s
Inserted 216.81k 0.1/s
Read 71.38M 19.5/s
Updated 142.65k 0.0/s
|
