|
Mysql status
MySQL 10.5.29-MariaDB-0 uptime 10 19:57:10 Tue Jul 8 14:50:01 2025
__ Key _________________________________________________________________
Buffer used 4.87M of 16.00M %Used: 30.43
Current 4.08M %Usage: 25.52
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 62.90M 67.2/s
DMS 20.33M 21.7/s %Total: 32.32
Com_ 17.95M 19.2/s 28.54
COM_QUIT 16.73M 17.9/s 26.59
QC Hits 10.59M 11.3/s 16.84
-Unknown 2.70M 2.9/s 4.29
Slow 17 0.0/s 0.00 %DMS: 0.00
DMS 20.33M 21.7/s 32.32
SELECT 11.55M 12.3/s 18.37 56.82
INSERT 8.65M 9.2/s 13.76 42.56
UPDATE 124.91k 0.1/s 0.20 0.61
DELETE 750 0.0/s 0.00 0.00
REPLACE 3 0.0/s 0.00 0.00
Com_ 17.95M 19.2/s 28.54
change_db 16.83M 18.0/s 26.75
set_option 665.35k 0.7/s 1.06
show_create 108.36k 0.1/s 0.17
__ SELECT and Sort _____________________________________________________
Scan 693.55k 0.7/s %SELECT: 6.00
Range 10.80k 0.0/s 0.09
Full join 14.76k 0.0/s 0.13
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 124.63k 0.1/s
Sort range 126.55k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 1.01M of 16.00M %Used: 6.34
Block Fragmnt 6.12%
Hits 10.59M 11.3/s
Inserts 344.37k 0.4/s
Insrt:Prune 344.37k:1 0.4/s
Hit:Insert 30.75:1
__ Table Locks _________________________________________________________
Waited 4 0.0/s %Total: 0.00
Immediate 10.12M 10.8/s
__ Tables ______________________________________________________________
Open 141 of %Cache: 14100.
Opened 196.52k 0.2/s
__ Connections _________________________________________________________
Max used 38 of 100 %Max: 38.00
Total 16.73M 17.9/s
__ Created Temp ________________________________________________________
Disk table 325.32k 0.3/s
Table 575.47k 0.6/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 1 of 5
Cached 3 of 8 %Hit: 99.78
Created 36.68k 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 70 0.0/s
Connects 1.49k 0.0/s
__ Bytes _______________________________________________________________
Sent 87.47G 93.5k/s
Received 21.89G 23.4k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 119.22M of 126.02M %Used: 94.61
Read ratio 0.000
Pages
Free 435 %Total: 5.39
Data 7.15k 88.64 %Drty: 4.71
Misc 481 5.96
Latched 0.00
Reads 82.70M 88.4/s
From file 5.85k 0.0/s 0.01
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 441.61k 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 138.29k 0.1/s
fsync 138.29k 0.1/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 205 0.0/s
Read 6.94k 0.0/s
Written 0 0/s
Rows
Deleted 2 0.0/s
Inserted 3 0.0/s
Read 83.75M 89.5/s
Updated 71.94k 0.1/s
|