|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 0 20:29:56 Tue Apr 1 22:30:01 2025
__ Key _________________________________________________________________
Buffer used 4.80M of 32.00M %Used: 14.99
Current 6.26M %Usage: 19.55
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 1.18M 16.0/s
DMS 1.01M 13.7/s %Total: 85.72
-Unknown 244.82k 3.3/s 20.69
QC Hits 225.77k 3.1/s 19.08
Com_ 144.46k 2.0/s 12.21
COM_QUIT 43.49k 0.6/s 3.68
Slow 5 0.0/s 0.00 %DMS: 0.00
DMS 1.01M 13.7/s 85.72
INSERT 697.19k 9.4/s 58.93 68.74
SELECT 306.89k 4.2/s 25.94 30.26
UPDATE 10.09k 0.1/s 0.85 0.99
DELETE 67 0.0/s 0.01 0.01
REPLACE 2 0.0/s 0.00 0.00
Com_ 144.46k 2.0/s 12.21
set_option 59.99k 0.8/s 5.07
change_db 45.26k 0.6/s 3.83
show_create 9.73k 0.1/s 0.82
__ SELECT and Sort _____________________________________________________
Scan 44.43k 0.6/s %SELECT: 14.48
Range 176 0.0/s 0.06
Full join 22 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 9.93k 0.1/s
Sort range 12.08k 0.2/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 4.63M of 64.00M %Used: 7.23
Block Fragmnt 7.42%
Hits 225.77k 3.1/s
Inserts 30.55k 0.4/s
Insrt:Prune 30.55k:1 0.4/s
Hit:Insert 7.39:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 805.30k 10.9/s
__ Tables ______________________________________________________________
Open 134 of %Cache: 13400.
Opened 24.92k 0.3/s
__ Connections _________________________________________________________
Max used 36 of 100 %Max: 36.00
Total 43.49k 0.6/s
__ Created Temp ________________________________________________________
Disk table 26.39k 0.4/s
Table 41.54k 0.6/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 7 of 8
Cached 28 of 64 %Hit: 99.92
Created 36 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 2 0.0/s
Connects 109 0.0/s
__ Bytes _______________________________________________________________
Sent 6.36G 86.2k/s
Received 1.23G 16.6k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 107.17M of 128.00M %Used: 83.73
Read ratio 0.004
Pages
Free 1.33k %Total: 16.27
Data 6.35k 77.55 %Drty: 0.00
Misc 506 6.18
Latched 0.00
Reads 1.39M 18.8/s
From file 5.30k 0.1/s 0.38
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 43.79k 0.6/s
Flushes 16.48k 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 6.29k 0.1/s
Writes 50.13k 0.7/s
fsync 43.83k 0.6/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 132 0.0/s
Read 6.22k 0.1/s
Written 16.48k 0.2/s
Rows
Deleted 1 0.0/s
Inserted 2 0.0/s
Read 1.95M 26.5/s
Updated 5.91k 0.1/s
|
