|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 0 7:55:39 Tue Oct 22 20:20:01 2024
__ Key _________________________________________________________________
Buffer used 2.04M of 32.00M %Used: 6.39
Current 7.60M %Usage: 23.74
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 463.34k 16.2/s
DMS 434.64k 15.2/s %Total: 93.81
-Unknown 54.55k 1.9/s 11.77
QC Hits 47.84k 1.7/s 10.32
Com_ 20.09k 0.7/s 4.34
COM_QUIT 15.33k 0.5/s 3.31
Slow 1 0.0/s 0.00 %DMS: 0.00
DMS 434.64k 15.2/s 93.81
INSERT 364.52k 12.8/s 78.67 83.87
SELECT 66.58k 2.3/s 14.37 15.32
UPDATE 3.52k 0.1/s 0.76 0.81
DELETE 12 0.0/s 0.00 0.00
REPLACE 0 0/s 0.00 0.00
Com_ 20.09k 0.7/s 4.34
change_db 7.50k 0.3/s 1.62
set_option 4.89k 0.2/s 1.06
stmt_execut 2.29k 0.1/s 0.49
__ SELECT and Sort _____________________________________________________
Scan 4.45k 0.2/s %SELECT: 6.68
Range 80 0.0/s 0.12
Full join 11 0.0/s 0.02
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 4.67k 0.2/s
Sort range 1.14k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 4.31M of 64.00M %Used: 6.74
Block Fragmnt 0.79%
Hits 47.84k 1.7/s
Inserts 7.85k 0.3/s
Insrt:Prune 7.85k:1 0.3/s
Hit:Insert 6.09:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 407.57k 14.3/s
__ Tables ______________________________________________________________
Open 111 of %Cache: 11100.
Opened 8.79k 0.3/s
__ Connections _________________________________________________________
Max used 21 of 100 %Max: 21.00
Total 15.33k 0.5/s
__ Created Temp ________________________________________________________
Disk table 4.47k 0.2/s
Table 5.79k 0.2/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 2
Cached 19 of 64 %Hit: 99.86
Created 21 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 1 0.0/s
Connects 3 0.0/s
__ Bytes _______________________________________________________________
Sent 998.01M 35.0k/s
Received 579.77M 20.3k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 32.33M of 128.00M %Used: 25.26
Read ratio 0.004
Pages
Free 6.12k %Total: 74.74
Data 2.62k 32.03 %Drty: 0.00
Misc 184467440 225179
Latched 0.00
Reads 566.20k 19.8/s
From file 2.49k 0.1/s 0.44
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 16.28k 0.6/s
Flushes 6.25k 0.2/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 2.54k 0.1/s
Writes 18.42k 0.6/s
fsync 16.03k 0.6/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 131 0.0/s
Read 2.49k 0.1/s
Written 6.25k 0.2/s
Rows
Deleted 0 0/s
Inserted 2 0.0/s
Read 495.46k 17.4/s
Updated 2.14k 0.1/s
|
