|
Mysql status
MySQL 5.5.62-0+deb8u1-l uptime 13 23:58:19 Tue Apr 7 20:40:02 2020
__ Key _________________________________________________________________
Buffer used 12.63M of 128.00M %Used: 9.87
Current 24.59M %Usage: 19.21
Write ratio 0.578
Read ratio 0.010
__ Questions ___________________________________________________________
Total 23.83M 19.7/s
QC Hits 10.58M 8.7/s %Total: 44.39
DMS 8.58M 7.1/s 36.01
Com_ 3.87M 3.2/s 16.26
COM_QUIT 793.90k 0.7/s 3.33
+Unknown 2.84k 0.0/s 0.01
Slow 3.37k 0.0/s 0.01 %DMS: 0.04
DMS 8.58M 7.1/s 36.01
SELECT 5.73M 4.7/s 24.03 66.75
UPDATE 1.69M 1.4/s 7.08 19.65
INSERT 582.07k 0.5/s 2.44 6.78
DELETE 412.43k 0.3/s 1.73 4.81
REPLACE 172.38k 0.1/s 0.72 2.01
Com_ 3.87M 3.2/s 16.26
set_option 1.88M 1.6/s 7.89
change_db 1.36M 1.1/s 5.70
show_fields 143.32k 0.1/s 0.60
__ SELECT and Sort _____________________________________________________
Scan 1.76M 1.5/s %SELECT: 30.66
Range 1.05M 0.9/s 18.32
Full join 8.26k 0.0/s 0.14
Range check 0 0/s 0.00
Full rng join 8 0.0/s 0.00
Sort scan 882.91k 0.7/s
Sort range 393.53k 0.3/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 13.91M of 64.00M %Used: 21.73
Block Fragmnt 0.18%
Hits 10.58M 8.7/s
Inserts 4.80M 4.0/s
Insrt:Prune 13.10:1 3.7/s
Hit:Insert 2.20:1
__ Table Locks _________________________________________________________
Waited 4.20k 0.0/s %Total: 0.04
Immediate 9.48M 7.8/s
__ Tables ______________________________________________________________
Open 228 of %Cache: 22800.
Opened 372.14k 0.3/s
__ Connections _________________________________________________________
Max used 64 of 200 %Max: 32.00
Total 794.34k 0.7/s
__ Created Temp ________________________________________________________
Disk table 352.04k 0.3/s
Table 693.92k 0.6/s
File 8 0.0/s
__ Threads _____________________________________________________________
Running 1 of 2
Cached 62 of 64 %Hit: 99.99
Created 64 0.0/s
Slow 1 0.0/s
__ Aborted _____________________________________________________________
Clients 890 0.0/s
Connects 641 0.0/s
__ Bytes _______________________________________________________________
Sent 106.25G 87.8k/s
Received 4.25G 3.5k/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.15k 99.54 %Drty: 0.00
Misc 38 0.46
Latched 0.00
Reads 32.10M 26.5/s
From file 8.30k 0.0/s 0.03
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 1.81M 1.5/s
Flushes 330.58k 0.3/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 27 0.0/s
Current 0
Time acquiring
Total 263 ms
Average 9 ms
Max 246 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 8.61k 0.0/s
Writes 469.25k 0.4/s
fsync 155.98k 0.1/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 5.34k 0.0/s
Read 8.60k 0.0/s
Written 330.58k 0.3/s
Rows
Deleted 75.19k 0.1/s
Inserted 72.85k 0.1/s
Read 18.29M 15.1/s
Updated 40.11k 0.0/s
|
