|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 20 0:17:21 Thu Sep 21 23:10:01 2023
__ Key _________________________________________________________________
Buffer used 7.27M of 32.00M %Used: 22.73
Current 8.77M %Usage: 27.41
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 42.99M 24.9/s
DMS 40.47M 23.4/s %Total: 94.13
Com_ 3.00M 1.7/s 6.97
-Unknown 2.80M 1.6/s 6.51
QC Hits 1.91M 1.1/s 4.44
COM_QUIT 413.24k 0.2/s 0.96
Slow 86 0.0/s 0.00 %DMS: 0.00
DMS 40.47M 23.4/s 94.13
INSERT 36.88M 21.3/s 85.77 91.12
SELECT 3.26M 1.9/s 7.58 8.05
UPDATE 330.58k 0.2/s 0.77 0.82
DELETE 5.10k 0.0/s 0.01 0.01
REPLACE 4 0.0/s 0.00 0.00
Com_ 3.00M 1.7/s 6.97
set_option 1.09M 0.6/s 2.54
change_db 583.21k 0.3/s 1.36
stmt_execut 334.99k 0.2/s 0.78
__ SELECT and Sort _____________________________________________________
Scan 879.70k 0.5/s %SELECT: 27.01
Range 24.30k 0.0/s 0.75
Full join 200 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 126.61k 0.1/s
Sort range 126.66k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 1.76M of 64.00M %Used: 2.75
Block Fragmnt 0.06%
Hits 1.91M 1.1/s
Inserts 475.96k 0.3/s
Insrt:Prune 475.96k:1 0.3/s
Hit:Insert 4.01:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 38.05M 22.0/s
__ Tables ______________________________________________________________
Open 117 of %Cache: 11700.
Opened 348.78k 0.2/s
__ Connections _________________________________________________________
Max used 54 of 100 %Max: 54.00
Total 413.27k 0.2/s
__ Created Temp ________________________________________________________
Disk table 470.37k 0.3/s
Table 764.11k 0.4/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 2
Cached 24 of 64 %Hit: 99.96
Created 157 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 61 0.0/s
Connects 23.68k 0.0/s
__ Bytes _______________________________________________________________
Sent 161.16G 93.2k/s
Received 48.60G 28.1k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 107.44M of 128.00M %Used: 83.94
Read ratio 0.000
Pages
Free 1.32k %Total: 16.06
Data 6.19k 75.59 %Drty: 0.00
Misc 684 8.35
Latched 0.00
Reads 177.86M 102.9/s
From file 5.05k 0.0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 9.94M 5.7/s
Flushes 1.14M 0.7/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 7 0.0/s
Current 0
Time acquiring
Total 98 ms
Average 14 ms
Max 31 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 5.50k 0.0/s
Writes 2.10M 1.2/s
fsync 1.29M 0.7/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 759 0.0/s
Read 5.43k 0.0/s
Written 1.14M 0.7/s
Rows
Deleted 74.28k 0.0/s
Inserted 81.13k 0.0/s
Read 125.12M 72.4/s
Updated 1.08M 0.6/s
|
