|
Mysql status
MySQL 5.5.62-0+deb8u1-l uptime 28 0:24:57 Wed Jun 3 13:30:02 2020
__ Key _________________________________________________________________
Buffer used 14.70M of 128.00M %Used: 11.48
Current 26.51M %Usage: 20.71
Write ratio 0.491
Read ratio 0.013
__ Questions ___________________________________________________________
Total 49.95M 20.6/s
QC Hits 22.50M 9.3/s %Total: 45.05
DMS 17.34M 7.2/s 34.72
Com_ 8.42M 3.5/s 16.86
COM_QUIT 1.68M 0.7/s 3.36
+Unknown 7.16k 0.0/s 0.01
Slow 838 0.0/s 0.00 %DMS: 0.00
DMS 17.34M 7.2/s 34.72
SELECT 12.01M 5.0/s 24.05 69.28
UPDATE 3.06M 1.3/s 6.13 17.66
DELETE 937.25k 0.4/s 1.88 5.41
INSERT 892.02k 0.4/s 1.79 5.14
REPLACE 434.38k 0.2/s 0.87 2.51
Com_ 8.42M 3.5/s 16.86
set_option 4.00M 1.7/s 8.02
change_db 3.13M 1.3/s 6.27
show_fields 286.61k 0.1/s 0.57
__ SELECT and Sort _____________________________________________________
Scan 3.19M 1.3/s %SELECT: 26.59
Range 2.16M 0.9/s 17.98
Full join 18.44k 0.0/s 0.15
Range check 0 0/s 0.00
Full rng join 25 0.0/s 0.00
Sort scan 1.69M 0.7/s
Sort range 1.33M 0.5/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 42.56M of 64.00M %Used: 66.49
Block Fragmnt 1.23%
Hits 22.50M 9.3/s
Inserts 9.96M 4.1/s
Insrt:Prune 7.32:1 3.6/s
Hit:Insert 2.26:1
__ Table Locks _________________________________________________________
Waited 1.97k 0.0/s %Total: 0.01
Immediate 18.27M 7.5/s
__ Tables ______________________________________________________________
Open 431 of %Cache: 43100.
Opened 725.60k 0.3/s
__ Connections _________________________________________________________
Max used 38 of 200 %Max: 19.00
Total 1.68M 0.7/s
__ Created Temp ________________________________________________________
Disk table 756.30k 0.3/s
Table 1.44M 0.6/s
File 11 0.0/s
__ Threads _____________________________________________________________
Running 2 of 3
Cached 35 of 64 %Hit: 100
Created 38 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 875 0.0/s
Connects 756 0.0/s
__ Bytes _______________________________________________________________
Sent 219.29G 90.6k/s
Received 8.23G 3.4k/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.55 %Drty: 0.10
Misc 36 0.44
Latched 0.00
Reads 96.73M 40.0/s
From file 9.43k 0.0/s 0.01
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 3.81M 1.6/s
Flushes 680.62k 0.3/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 2 0.0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 9.68k 0.0/s
Writes 966.11k 0.4/s
fsync 320.06k 0.1/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 7.37k 0.0/s
Read 9.67k 0.0/s
Written 680.62k 0.3/s
Rows
Deleted 161.73k 0.1/s
Inserted 146.44k 0.1/s
Read 61.92M 25.6/s
Updated 84.98k 0.0/s
|
