|
Mysql status
MySQL 5.5.62-0+deb8u1-l uptime 17 19:10:17 Thu Oct 17 15:10:01 2019
__ Key _________________________________________________________________
Buffer used 42.14M of 128.00M %Used: 32.92
Current 27.88M %Usage: 21.78
Write ratio 0.446
Read ratio 0.001
__ Questions ___________________________________________________________
Total 45.06M 29.3/s
QC Hits 20.95M 13.6/s %Total: 46.51
DMS 15.65M 10.2/s 34.72
Com_ 7.32M 4.8/s 16.24
COM_QUIT 1.15M 0.7/s 2.56
-Unknown 12.90k 0.0/s 0.03
Slow 3.01k 0.0/s 0.01 %DMS: 0.02
DMS 15.65M 10.2/s 34.72
SELECT 10.12M 6.6/s 22.46 64.67
UPDATE 3.45M 2.2/s 7.65 22.03
DELETE 996.23k 0.6/s 2.21 6.37
REPLACE 611.62k 0.4/s 1.36 3.91
INSERT 471.98k 0.3/s 1.05 3.02
Com_ 7.32M 4.8/s 16.24
change_db 3.14M 2.0/s 6.98
set_option 3.01M 2.0/s 6.67
repair 332.98k 0.2/s 0.74
__ SELECT and Sort _____________________________________________________
Scan 2.01M 1.3/s %SELECT: 19.83
Range 1.88M 1.2/s 18.53
Full join 7.11k 0.0/s 0.07
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 1.14M 0.7/s
Sort range 1.30M 0.8/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 28.71M of 64.00M %Used: 44.86
Block Fragmnt 1.88%
Hits 20.95M 13.6/s
Inserts 8.29M 5.4/s
Insrt:Prune 25.99:1 5.2/s
Hit:Insert 2.53:1
__ Table Locks _________________________________________________________
Waited 27.00k 0.0/s %Total: 0.19
Immediate 14.49M 9.4/s
__ Tables ______________________________________________________________
Open 349 of %Cache: 34900.
Opened 472.33k 0.3/s
__ Connections _________________________________________________________
Max used 56 of 200 %Max: 28.00
Total 1.15M 0.7/s
__ Created Temp ________________________________________________________
Disk table 446.86k 0.3/s
Table 846.90k 0.6/s
File 10 0.0/s
__ Threads _____________________________________________________________
Running 1 of 6
Cached 50 of 64 %Hit: 100
Created 56 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 321 0.0/s
Connects 63 0.0/s
__ Bytes _______________________________________________________________
Sent 301.39G 196.0k/s
Received 6.88G 4.5k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 127.86M of 127.98M %Used: 99.90
Read ratio 0.000
Pages
Free 8 %Total: 0.10
Data 8.10k 98.93 %Drty: 0.00
Misc 80 0.98
Latched 0.00
Reads 49.25M 32.0/s
From file 8.92k 0.0/s 0.02
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 1.81M 1.2/s
Flushes 372.02k 0.2/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 6 0.0/s
Current 0
Time acquiring
Total 208 ms
Average 34 ms
Max 126 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 9.29k 0.0/s
Writes 514.57k 0.3/s
fsync 157.82k 0.1/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 4.55k 0.0/s
Read 9.28k 0.0/s
Written 372.02k 0.2/s
Rows
Deleted 78.94k 0.1/s
Inserted 62.08k 0.0/s
Read 32.57M 21.2/s
Updated 56.14k 0.0/s
|
