|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 0 3:59:58 Wed Jan 22 06:00:02 2025
__ Key _________________________________________________________________
Buffer used 4.59M of 32.00M %Used: 14.35
Current 9.09M %Usage: 28.42
Write ratio 1.000
Read ratio 0.002
__ Questions ___________________________________________________________
Total 312.91k 21.7/s
DMS 212.64k 14.8/s %Total: 67.95
Com_ 86.86k 6.0/s 27.76
-Unknown 25.64k 1.8/s 8.19
QC Hits 22.34k 1.6/s 7.14
COM_QUIT 16.72k 1.2/s 5.34
Slow 5 0.0/s 0.00 %DMS: 0.00
DMS 212.64k 14.8/s 67.95
INSERT 137.45k 9.5/s 43.93 64.64
SELECT 73.46k 5.1/s 23.48 34.55
UPDATE 1.72k 0.1/s 0.55 0.81
DELETE 5 0.0/s 0.00 0.00
REPLACE 0 0/s 0.00 0.00
Com_ 86.86k 6.0/s 27.76
set_option 47.26k 3.3/s 15.10
change_db 17.77k 1.2/s 5.68
show_create 9.27k 0.6/s 2.96
__ SELECT and Sort _____________________________________________________
Scan 34.07k 2.4/s %SELECT: 46.38
Range 31 0.0/s 0.04
Full join 4 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 1.21k 0.1/s
Sort range 2.87k 0.2/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 1.58M of 64.00M %Used: 2.47
Block Fragmnt 6.22%
Hits 22.34k 1.6/s
Inserts 5.67k 0.4/s
Insrt:Prune 5.67k:1 0.4/s
Hit:Insert 3.94:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 164.62k 11.4/s
__ Tables ______________________________________________________________
Open 1.02k of %Cache: 102300
Opened 23.61k 1.6/s
__ Connections _________________________________________________________
Max used 10 of 100 %Max: 10.00
Total 16.72k 1.2/s
__ Created Temp ________________________________________________________
Disk table 18.56k 1.3/s
Table 30.50k 2.1/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 7 of 7
Cached 3 of 64 %Hit: 99.94
Created 10 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 2 0.0/s
Connects 3 0.0/s
__ Bytes _______________________________________________________________
Sent 4.81G 334.0k/s
Received 248.87M 17.3k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 107.95M of 128.00M %Used: 84.34
Read ratio 0.015
Pages
Free 1.28k %Total: 15.66
Data 6.41k 78.22 %Drty: 0.00
Misc 501 6.12
Latched 0.00
Reads 347.83k 24.2/s
From file 5.36k 0.4/s 1.54
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 8.13k 0.6/s
Flushes 3.26k 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.35k 0.4/s
Writes 9.45k 0.7/s
fsync 8.20k 0.6/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 131 0.0/s
Read 6.28k 0.4/s
Written 3.26k 0.2/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 621.74k 43.2/s
Updated 1.03k 0.1/s
|
