|
Mysql status
MySQL 10.1.48-MariaDB-0 uptime 29 8:50:8 Tue Nov 30 07:20:02 2021
__ Key _________________________________________________________________
Buffer used 39.65M of 128.00M %Used: 30.97
Current 31.37M %Usage: 24.50
Write ratio 0.564
Read ratio 0.022
__ Questions ___________________________________________________________
Total 19.26M 7.6/s
DMS 13.82M 5.4/s %Total: 71.77
-Unknown 7.04M 2.8/s 36.53
QC Hits 6.93M 2.7/s 36.00
Com_ 4.32M 1.7/s 22.42
COM_QUIT 1.22M 0.5/s 6.34
Slow 1.43k 0.0/s 0.01 %DMS: 0.01
DMS 13.82M 5.4/s 71.77
SELECT 11.92M 4.7/s 61.87 86.20
UPDATE 1.22M 0.5/s 6.32 8.80
INSERT 454.00k 0.2/s 2.36 3.28
DELETE 232.56k 0.1/s 1.21 1.68
REPLACE 4.37k 0.0/s 0.02 0.03
Com_ 4.32M 1.7/s 22.42
set_option 2.02M 0.8/s 10.47
change_db 1.55M 0.6/s 8.04
show_fields 309.12k 0.1/s 1.61
__ SELECT and Sort _____________________________________________________
Scan 1.87M 0.7/s %SELECT: 15.73
Range 553.56k 0.2/s 4.65
Full join 10.29k 0.0/s 0.09
Range check 0 0/s 0.00
Full rng join 12 0.0/s 0.00
Sort scan 379.20k 0.1/s
Sort range 70.87k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 26.76M of 64.00M %Used: 41.81
Block Fragmnt 2.41%
Hits 6.93M 2.7/s
Inserts 3.55M 1.4/s
Insrt:Prune 274.18:1 1.4/s
Hit:Insert 1.95:1
__ Table Locks _________________________________________________________
Waited 1.04k 0.0/s %Total: 0.01
Immediate 9.16M 3.6/s
__ Tables ______________________________________________________________
Open 241 of %Cache: 24100.
Opened 656.32k 0.3/s
__ Connections _________________________________________________________
Max used 43 of 200 %Max: 21.50
Total 1.22M 0.5/s
__ Created Temp ________________________________________________________
Disk table 845.63k 0.3/s
Table 1.31M 0.5/s
File 6 0.0/s
__ Threads _____________________________________________________________
Running 1 of 5
Cached 38 of 64 %Hit: 100
Created 43 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 5 0.0/s
Connects 5.26k 0.0/s
__ Bytes _______________________________________________________________
Sent 179.74G 70.8k/s
Received 3.72G 1.5k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 62.62M of 127.98M %Used: 48.93
Read ratio 0.000
Pages
Free 4.18k %Total: 51.07
Data 3.98k 48.65 %Drty: 0.00
Misc 23 0.28
Latched 0.00
Reads 927.15M 365.4/s
From file 3.53k 0.0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 31.53k 0.0/s
Flushes 13.15k 0.0/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 1 0.0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 4.01k 0.0/s
Writes 20.92k 0.0/s
fsync 9.28k 0.0/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 95 0.0/s
Read 3.89k 0.0/s
Written 13.15k 0.0/s
Rows
Deleted 0 0/s
Inserted 478 0.0/s
Read 54.68M 21.6/s
Updated 3.27k 0.0/s
|
