|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 0 17:39:56 Wed May 7 19:40:01 2025
__ Key _________________________________________________________________
Buffer used 4.78M of 32.00M %Used: 14.94
Current 7.10M %Usage: 22.19
Write ratio 1.000
Read ratio 0.001
__ Questions ___________________________________________________________
Total 1.06M 16.7/s
DMS 906.16k 14.2/s %Total: 85.30
-Unknown 241.84k 3.8/s 22.77
QC Hits 226.51k 3.6/s 21.32
Com_ 135.87k 2.1/s 12.79
COM_QUIT 35.60k 0.6/s 3.35
Slow 4 0.0/s 0.00 %DMS: 0.00
DMS 906.16k 14.2/s 85.30
INSERT 587.30k 9.2/s 55.29 64.81
SELECT 310.56k 4.9/s 29.23 34.27
UPDATE 8.25k 0.1/s 0.78 0.91
DELETE 41 0.0/s 0.00 0.00
REPLACE 3 0.0/s 0.00 0.00
Com_ 135.87k 2.1/s 12.79
set_option 63.23k 1.0/s 5.95
change_db 37.24k 0.6/s 3.51
show_create 9.65k 0.2/s 0.91
__ SELECT and Sort _____________________________________________________
Scan 40.61k 0.6/s %SELECT: 13.08
Range 213 0.0/s 0.07
Full join 20 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 4.74k 0.1/s
Sort range 8.69k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 2.57M of 64.00M %Used: 4.02
Block Fragmnt 2.75%
Hits 226.51k 3.6/s
Inserts 22.34k 0.4/s
Insrt:Prune 22.34k:1 0.4/s
Hit:Insert 10.14:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 651.15k 10.2/s
__ Tables ______________________________________________________________
Open 113 of %Cache: 11300.
Opened 24.83k 0.4/s
__ Connections _________________________________________________________
Max used 40 of 100 %Max: 40.00
Total 35.61k 0.6/s
__ Created Temp ________________________________________________________
Disk table 21.76k 0.3/s
Table 35.68k 0.6/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 7 of 3
Cached 37 of 64 %Hit: 99.89
Created 40 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 4 0.0/s
Connects 137 0.0/s
__ Bytes _______________________________________________________________
Sent 6.28G 98.7k/s
Received 1.02G 16.1k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 106.64M of 128.00M %Used: 83.31
Read ratio 0.005
Pages
Free 1.37k %Total: 16.69
Data 6.32k 77.19 %Drty: 0.00
Misc 502 6.13
Latched 0.00
Reads 1.15M 18.1/s
From file 5.27k 0.1/s 0.46
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 35.35k 0.6/s
Flushes 14.51k 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.26k 0.1/s
Writes 44.00k 0.7/s
fsync 38.67k 0.6/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 132 0.0/s
Read 6.19k 0.1/s
Written 14.51k 0.2/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 1.68M 26.5/s
Updated 4.78k 0.1/s
|
