|
Mysql status
MySQL 5.5.62-0+deb8u1-l uptime 14 11:40:4 Fri Dec 13 23:20:01 2019
__ Key _________________________________________________________________
Buffer used 10.17M of 128.00M %Used: 7.95
Current 25.92M %Usage: 20.25
Write ratio 0.525
Read ratio 0.007
__ Questions ___________________________________________________________
Total 42.14M 33.7/s
QC Hits 20.23M 16.2/s %Total: 48.00
DMS 14.06M 11.2/s 33.36
Com_ 6.46M 5.2/s 15.32
COM_QUIT 1.40M 1.1/s 3.33
-Unknown 2.70k 0.0/s 0.01
Slow 5.92k 0.0/s 0.01 %DMS: 0.04
DMS 14.06M 11.2/s 33.36
SELECT 8.19M 6.5/s 19.44 58.27
UPDATE 3.81M 3.0/s 9.04 27.08
DELETE 982.38k 0.8/s 2.33 6.99
INSERT 588.37k 0.5/s 1.40 4.18
REPLACE 487.88k 0.4/s 1.16 3.47
Com_ 6.46M 5.2/s 15.32
set_option 2.88M 2.3/s 6.83
change_db 2.79M 2.2/s 6.63
repair 143.48k 0.1/s 0.34
__ SELECT and Sort _____________________________________________________
Scan 1.61M 1.3/s %SELECT: 19.59
Range 1.41M 1.1/s 17.22
Full join 34.78k 0.0/s 0.42
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 768.07k 0.6/s
Sort range 644.97k 0.5/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 41.28M of 64.00M %Used: 64.50
Block Fragmnt 0.22%
Hits 20.23M 16.2/s
Inserts 6.30M 5.0/s
Insrt:Prune 17.79:1 4.8/s
Hit:Insert 3.21:1
__ Table Locks _________________________________________________________
Waited 12.38k 0.0/s %Total: 0.09
Immediate 14.18M 11.3/s
__ Tables ______________________________________________________________
Open 381 of %Cache: 38100.
Opened 386.25k 0.3/s
__ Connections _________________________________________________________
Max used 62 of 200 %Max: 31.00
Total 1.40M 1.1/s
__ Created Temp ________________________________________________________
Disk table 354.32k 0.3/s
Table 698.70k 0.6/s
File 8 0.0/s
__ Threads _____________________________________________________________
Running 1 of 6
Cached 56 of 64 %Hit: 100
Created 62 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 176 0.0/s
Connects 61 0.0/s
__ Bytes _______________________________________________________________
Sent 120.53G 96.3k/s
Received 6.83G 5.5k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 127.97M of 127.98M %Used: 99.99
Read ratio 0.000
Pages
Free 1 %Total: 0.01
Data 8.15k 99.51 %Drty: 0.00
Misc 39 0.48
Latched 0.00
Reads 37.74M 30.2/s
From file 8.08k 0.0/s 0.02
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 1.30M 1.0/s
Flushes 342.52k 0.3/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 5 0.0/s
Current 0
Time acquiring
Total 190 ms
Average 38 ms
Max 102 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 8.25k 0.0/s
Writes 474.83k 0.4/s
fsync 147.54k 0.1/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 3.21k 0.0/s
Read 8.24k 0.0/s
Written 342.52k 0.3/s
Rows
Deleted 47.82k 0.0/s
Inserted 57.23k 0.0/s
Read 24.67M 19.7/s
Updated 52.31k 0.0/s
|
