|
Mysql status
MySQL 10.5.29-MariaDB-0 uptime 14 6:57:10 Sat Jul 12 01:50:01 2025
__ Key _________________________________________________________________
Buffer used 4.88M of 16.00M %Used: 30.47
Current 4.11M %Usage: 25.70
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 66.90M 54.2/s
DMS 23.86M 19.3/s %Total: 35.66
Com_ 18.39M 14.9/s 27.49
COM_QUIT 16.83M 13.6/s 25.16
QC Hits 11.05M 8.9/s 16.51
-Unknown 3.23M 2.6/s 4.83
Slow 22 0.0/s 0.00 %DMS: 0.00
DMS 23.86M 19.3/s 35.66
SELECT 12.25M 9.9/s 18.31 51.36
INSERT 11.44M 9.3/s 17.10 47.95
UPDATE 165.13k 0.1/s 0.25 0.69
DELETE 950 0.0/s 0.00 0.00
REPLACE 5 0.0/s 0.00 0.00
Com_ 18.39M 14.9/s 27.49
change_db 16.96M 13.7/s 25.36
set_option 831.57k 0.7/s 1.24
show_create 138.24k 0.1/s 0.21
__ SELECT and Sort _____________________________________________________
Scan 832.34k 0.7/s %SELECT: 6.79
Range 12.82k 0.0/s 0.10
Full join 14.83k 0.0/s 0.12
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 146.12k 0.1/s
Sort range 169.36k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 2.58M of 16.00M %Used: 16.09
Block Fragmnt 5.54%
Hits 11.05M 8.9/s
Inserts 449.14k 0.4/s
Insrt:Prune 449.14k:1 0.4/s
Hit:Insert 24.59:1
__ Table Locks _________________________________________________________
Waited 4 0.0/s %Total: 0.00
Immediate 13.23M 10.7/s
__ Tables ______________________________________________________________
Open 285 of %Cache: 28500.
Opened 253.69k 0.2/s
__ Connections _________________________________________________________
Max used 57 of 100 %Max: 57.00
Total 16.83M 13.6/s
__ Created Temp ________________________________________________________
Disk table 397.36k 0.3/s
Table 693.39k 0.6/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 1 of 7
Cached 3 of 8 %Hit: 99.78
Created 36.80k 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 97 0.0/s
Connects 1.95k 0.0/s
__ Bytes _______________________________________________________________
Sent 108.27G 87.7k/s
Received 26.65G 21.6k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 119.39M of 126.02M %Used: 94.74
Read ratio 0.000
Pages
Free 424 %Total: 5.26
Data 7.16k 88.78 %Drty: 4.85
Misc 481 5.96
Latched 0.00
Reads 88.34M 71.5/s
From file 5.86k 0.0/s 0.01
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 583.95k 0.5/s
Flushes 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 7.02k 0.0/s
Writes 181.67k 0.1/s
fsync 181.68k 0.1/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 212 0.0/s
Read 6.95k 0.0/s
Written 0 0/s
Rows
Deleted 6 0.0/s
Inserted 9 0.0/s
Read 91.24M 73.9/s
Updated 95.00k 0.1/s
|
