|
Mysql status
MySQL 5.5.62-0+deb8u1-l uptime 8 10:57:58 Fri Aug 23 00:40:02 2019
__ Key _________________________________________________________________
Buffer used 11.31M of 128.00M %Used: 8.84
Current 24.46M %Usage: 19.11
Write ratio 0.569
Read ratio 0.006
__ Questions ___________________________________________________________
Total 15.15M 20.7/s
QC Hits 6.56M 9.0/s %Total: 43.32
DMS 5.54M 7.6/s 36.57
Com_ 2.58M 3.5/s 17.03
COM_QUIT 470.23k 0.6/s 3.10
-Unknown 2.67k 0.0/s 0.02
Slow 172 0.0/s 0.00 %DMS: 0.00
DMS 5.54M 7.6/s 36.57
SELECT 3.82M 5.2/s 25.22 68.96
UPDATE 998.47k 1.4/s 6.59 18.03
DELETE 340.08k 0.5/s 2.25 6.14
INSERT 214.47k 0.3/s 1.42 3.87
REPLACE 166.14k 0.2/s 1.10 3.00
Com_ 2.58M 3.5/s 17.03
set_option 1.20M 1.6/s 7.90
change_db 1.00M 1.4/s 6.63
show_table_ 80.73k 0.1/s 0.53
__ SELECT and Sort _____________________________________________________
Scan 820.06k 1.1/s %SELECT: 21.47
Range 684.87k 0.9/s 17.93
Full join 3.90k 0.0/s 0.10
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 434.20k 0.6/s
Sort range 384.69k 0.5/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 15.65M of 64.00M %Used: 24.46
Block Fragmnt 0.32%
Hits 6.56M 9.0/s
Inserts 3.19M 4.4/s
Insrt:Prune 9.90:1 3.9/s
Hit:Insert 2.06:1
__ Table Locks _________________________________________________________
Waited 1.60k 0.0/s %Total: 0.03
Immediate 5.37M 7.4/s
__ Tables ______________________________________________________________
Open 207 of %Cache: 20700.
Opened 220.47k 0.3/s
__ Connections _________________________________________________________
Max used 15 of 200 %Max: 7.50
Total 470.25k 0.6/s
__ Created Temp ________________________________________________________
Disk table 191.79k 0.3/s
Table 394.49k 0.5/s
File 7 0.0/s
__ Threads _____________________________________________________________
Running 1 of 1
Cached 14 of 64 %Hit: 100
Created 15 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 42 0.0/s
Connects 45 0.0/s
__ Bytes _______________________________________________________________
Sent 61.81G 84.6k/s
Received 2.15G 2.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.13k 99.29 %Drty: 0.00
Misc 58 0.71
Latched 0.00
Reads 22.23M 30.4/s
From file 7.38k 0.0/s 0.03
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 624.49k 0.9/s
Flushes 166.66k 0.2/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 4 0.0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 7.56k 0.0/s
Writes 229.44k 0.3/s
fsync 70.99k 0.1/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 2.60k 0.0/s
Read 7.55k 0.0/s
Written 166.66k 0.2/s
Rows
Deleted 24.58k 0.0/s
Inserted 24.99k 0.0/s
Read 14.00M 19.2/s
Updated 25.79k 0.0/s
|
