|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 10 9:30:50 Thu Apr 25 03:40:01 2024
__ Key _________________________________________________________________
Buffer used 5.76M of 32.00M %Used: 18.01
Current 8.35M %Usage: 26.08
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 18.08M 20.1/s
DMS 16.63M 18.5/s %Total: 91.97
-Unknown 1.54M 1.7/s 8.52
Com_ 1.40M 1.6/s 7.73
QC Hits 1.26M 1.4/s 6.97
COM_QUIT 336.08k 0.4/s 1.86
Slow 40 0.0/s 0.00 %DMS: 0.00
DMS 16.63M 18.5/s 91.97
INSERT 14.56M 16.2/s 80.51 87.54
SELECT 1.95M 2.2/s 10.81 11.75
UPDATE 117.84k 0.1/s 0.65 0.71
DELETE 256 0.0/s 0.00 0.00
REPLACE 15 0.0/s 0.00 0.00
Com_ 1.40M 1.6/s 7.73
set_option 559.59k 0.6/s 3.09
change_db 388.37k 0.4/s 2.15
show_create 98.74k 0.1/s 0.55
__ SELECT and Sort _____________________________________________________
Scan 447.09k 0.5/s %SELECT: 22.87
Range 1.69k 0.0/s 0.09
Full join 129 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 77.25k 0.1/s
Sort range 69.35k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 1.60M of 64.00M %Used: 2.49
Block Fragmnt 0.34%
Hits 1.26M 1.4/s
Inserts 251.37k 0.3/s
Insrt:Prune 251.37k:1 0.3/s
Hit:Insert 5.01:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 15.29M 17.0/s
__ Tables ______________________________________________________________
Open 108 of %Cache: 10800.
Opened 175.41k 0.2/s
__ Connections _________________________________________________________
Max used 64 of 100 %Max: 64.00
Total 336.11k 0.4/s
__ Created Temp ________________________________________________________
Disk table 248.38k 0.3/s
Table 395.35k 0.4/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 5
Cached 5 of 64 %Hit: 99.98
Created 75 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 41 0.0/s
Connects 40.35k 0.0/s
__ Bytes _______________________________________________________________
Sent 78.60G 87.5k/s
Received 20.95G 23.3k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 112.00M of 128.00M %Used: 87.50
Read ratio 0.000
Pages
Free 1.02k %Total: 12.50
Data 6.66k 81.30 %Drty: 0.05
Misc 508 6.20
Latched 0.00
Reads 21.96M 24.5/s
From file 5.83k 0.0/s 0.03
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 527.62k 0.6/s
Flushes 192.46k 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.88k 0.0/s
Writes 563.53k 0.6/s
fsync 490.73k 0.5/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 133 0.0/s
Read 6.80k 0.0/s
Written 192.46k 0.2/s
Rows
Deleted 262 0.0/s
Inserted 27 0.0/s
Read 27.82M 31.0/s
Updated 69.07k 0.1/s
|
