|
Mysql status
MySQL 10.5.28-MariaDB-0 uptime 9 15:24:10 Sat May 24 10:10:01 2025
__ Key _________________________________________________________________
Buffer used 5.44M of 16.00M %Used: 34.02
Current 4.48M %Usage: 28.02
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 17.67M 21.2/s
DMS 15.22M 18.3/s %Total: 86.14
-Unknown 6.33M 7.6/s 35.84
QC Hits 6.18M 7.4/s 34.99
Com_ 1.98M 2.4/s 11.21
COM_QUIT 617.99k 0.7/s 3.50
Slow 44 0.0/s 0.00 %DMS: 0.00
DMS 15.22M 18.3/s 86.14
INSERT 7.76M 9.3/s 43.93 51.00
SELECT 7.35M 8.8/s 41.62 48.32
UPDATE 102.78k 0.1/s 0.58 0.68
DELETE 1.16k 0.0/s 0.01 0.01
REPLACE 30 0.0/s 0.00 0.00
Com_ 1.98M 2.4/s 11.21
set_option 897.18k 1.1/s 5.08
change_db 708.99k 0.9/s 4.01
show_create 98.24k 0.1/s 0.56
__ SELECT and Sort _____________________________________________________
Scan 476.29k 0.6/s %SELECT: 6.48
Range 14.12k 0.0/s 0.19
Full join 4.10k 0.0/s 0.06
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 49.40M 59.3/s
Sort range 133.86k 0.2/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 2.63M of 16.00M %Used: 16.43
Block Fragmnt 1.83%
Hits 6.18M 7.4/s
Inserts 341.03k 0.4/s
Insrt:Prune 341.03k:1 0.4/s
Hit:Insert 18.12:1
__ Table Locks _________________________________________________________
Waited 2 0.0/s %Total: 0.00
Immediate 9.02M 10.8/s
__ Tables ______________________________________________________________
Open 311 of %Cache: 31100.
Opened 192.52k 0.2/s
__ Connections _________________________________________________________
Max used 75 of 100 %Max: 75.00
Total 618.02k 0.7/s
__ Created Temp ________________________________________________________
Disk table 254.29k 0.3/s
Table 413.27k 0.5/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 1 of 1
Cached 7 of 8 %Hit: 99.35
Created 4.02k 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 42 0.0/s
Connects 614 0.0/s
__ Bytes _______________________________________________________________
Sent 91.02G 109.3k/s
Received 14.16G 17.0k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 119.00M of 126.02M %Used: 94.43
Read ratio 0.000
Pages
Free 449 %Total: 5.57
Data 7.14k 88.53 %Drty: 4.62
Misc 476 5.90
Latched 0.00
Reads 15.36M 18.4/s
From file 5.76k 0.0/s 0.04
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 320.21k 0.4/s
Flushes 0 0/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 6.91k 0.0/s
Writes 99.88k 0.1/s
fsync 99.88k 0.1/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 307 0.0/s
Read 6.83k 0.0/s
Written 0 0/s
Rows
Deleted 1 0.0/s
Inserted 3 0.0/s
Read 21.00M 25.2/s
Updated 52.14k 0.1/s
|