|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 0 16:49:56 Sat Dec 7 18:50:01 2024
__ Key _________________________________________________________________
Buffer used 4.95M of 32.00M %Used: 15.47
Current 7.28M %Usage: 22.76
Write ratio 1.000
Read ratio 0.001
__ Questions ___________________________________________________________
Total 905.95k 15.0/s
DMS 784.56k 12.9/s %Total: 86.60
Com_ 112.74k 1.9/s 12.44
-Unknown 74.18k 1.2/s 8.19
QC Hits 58.46k 1.0/s 6.45
COM_QUIT 24.37k 0.4/s 2.69
Slow 5 0.0/s 0.00 %DMS: 0.00
DMS 784.56k 12.9/s 86.60
INSERT 650.00k 10.7/s 71.75 82.85
SELECT 126.22k 2.1/s 13.93 16.09
UPDATE 8.31k 0.1/s 0.92 1.06
DELETE 33 0.0/s 0.00 0.00
REPLACE 0 0/s 0.00 0.00
Com_ 112.74k 1.9/s 12.44
set_option 50.92k 0.8/s 5.62
change_db 25.87k 0.4/s 2.86
show_create 9.65k 0.2/s 1.07
__ SELECT and Sort _____________________________________________________
Scan 40.43k 0.7/s %SELECT: 32.04
Range 163 0.0/s 0.13
Full join 329 0.0/s 0.26
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 3.58k 0.1/s
Sort range 6.36k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 747.73k of 64.00M %Used: 1.14
Block Fragmnt 4.07%
Hits 58.46k 1.0/s
Inserts 17.56k 0.3/s
Insrt:Prune 17.56k:1 0.3/s
Hit:Insert 3.33:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 701.94k 11.6/s
__ Tables ______________________________________________________________
Open 104 of %Cache: 10400.
Opened 24.56k 0.4/s
__ Connections _________________________________________________________
Max used 34 of 100 %Max: 34.00
Total 24.37k 0.4/s
__ Created Temp ________________________________________________________
Disk table 21.50k 0.4/s
Table 35.50k 0.6/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 2
Cached 32 of 64 %Hit: 99.86
Created 34 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 0 0/s
Connects 23 0.0/s
__ Bytes _______________________________________________________________
Sent 6.05G 99.9k/s
Received 1.09G 18.0k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 109.98M of 128.00M %Used: 85.93
Read ratio 0.004
Pages
Free 1.15k %Total: 14.07
Data 6.52k 79.63 %Drty: 0.00
Misc 516 6.30
Latched 0.00
Reads 1.30M 21.4/s
From file 5.46k 0.1/s 0.42
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 45.21k 0.7/s
Flushes 14.29k 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.46k 0.1/s
Writes 42.79k 0.7/s
fsync 37.30k 0.6/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 136 0.0/s
Read 6.39k 0.1/s
Written 14.29k 0.2/s
Rows
Deleted 293 0.0/s
Inserted 0 0/s
Read 1.82M 30.1/s
Updated 4.95k 0.1/s
|
