|
Mysql status
MySQL 10.1.48-MariaDB-0 uptime 3 14:56:57 Thu Mar 4 12:30:01 2021
__ Key _________________________________________________________________
Buffer used 5.96M of 128.00M %Used: 4.66
Current 26.89M %Usage: 21.01
Write ratio 0.554
Read ratio 0.021
__ Questions ___________________________________________________________
Total 2.23M 7.1/s
DMS 1.59M 5.1/s %Total: 71.27
-Unknown 706.85k 2.3/s 31.71
QC Hits 695.55k 2.2/s 31.20
Com_ 525.65k 1.7/s 23.58
COM_QUIT 125.99k 0.4/s 5.65
Slow 34 0.0/s 0.00 %DMS: 0.00
DMS 1.59M 5.1/s 71.27
SELECT 1.33M 4.2/s 59.65 83.69
UPDATE 166.04k 0.5/s 7.45 10.45
INSERT 60.29k 0.2/s 2.70 3.79
DELETE 31.91k 0.1/s 1.43 2.01
REPLACE 856 0.0/s 0.04 0.05
Com_ 525.65k 1.7/s 23.58
set_option 257.99k 0.8/s 11.57
change_db 168.40k 0.5/s 7.56
show_fields 41.66k 0.1/s 1.87
__ SELECT and Sort _____________________________________________________
Scan 235.65k 0.8/s %SELECT: 17.72
Range 71.39k 0.2/s 5.37
Full join 1.32k 0.0/s 0.10
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 40.17k 0.1/s
Sort range 8.74k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 39.21M of 64.00M %Used: 61.27
Block Fragmnt 4.71%
Hits 695.55k 2.2/s
Inserts 451.38k 1.4/s
Insrt:Prune 451.38k:1 1.4/s
Hit:Insert 1.54:1
__ Table Locks _________________________________________________________
Waited 58 0.0/s %Total: 0.01
Immediate 1.15M 3.7/s
__ Tables ______________________________________________________________
Open 203 of %Cache: 20300.
Opened 84.74k 0.3/s
__ Connections _________________________________________________________
Max used 50 of 200 %Max: 25.00
Total 125.99k 0.4/s
__ Created Temp ________________________________________________________
Disk table 105.89k 0.3/s
Table 164.62k 0.5/s
File 10 0.0/s
__ Threads _____________________________________________________________
Running 1 of 4
Cached 46 of 64 %Hit: 99.96
Created 50 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 3 0.0/s
Connects 471 0.0/s
__ Bytes _______________________________________________________________
Sent 22.41G 71.6k/s
Received 420.91M 1.3k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 76.58M of 127.98M %Used: 59.83
Read ratio 0.000
Pages
Free 3.29k %Total: 40.17
Data 4.88k 59.57 %Drty: 0.00
Misc 22 0.27
Latched 0.00
Reads 115.55M 369.1/s
From file 4.32k 0.0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 13.31k 0.0/s
Flushes 1.94k 0.0/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 4.83k 0.0/s
Writes 3.20k 0.0/s
fsync 1.58k 0.0/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 166 0.0/s
Read 4.71k 0.0/s
Written 1.94k 0.0/s
Rows
Deleted 4 0.0/s
Inserted 30 0.0/s
Read 6.42M 20.5/s
Updated 411 0.0/s
|