|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 0 2:49:57 Mon Apr 7 04:50:01 2025
__ Key _________________________________________________________________
Buffer used 1.64M of 32.00M %Used: 5.14
Current 7.11M %Usage: 22.23
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 170.62k 16.7/s
DMS 140.19k 13.7/s %Total: 82.16
-Unknown 32.78k 3.2/s 19.22
QC Hits 29.61k 2.9/s 17.36
COM_QUIT 18.15k 1.8/s 10.64
Com_ 15.45k 1.5/s 9.06
Slow 3 0.0/s 0.00 %DMS: 0.00
DMS 140.19k 13.7/s 82.16
INSERT 94.68k 9.3/s 55.49 67.54
SELECT 43.59k 4.3/s 25.55 31.09
UPDATE 1.90k 0.2/s 1.12 1.36
DELETE 15 0.0/s 0.01 0.01
REPLACE 0 0/s 0.00 0.00
Com_ 15.45k 1.5/s 9.06
change_db 10.03k 1.0/s 5.88
stmt_execut 1.27k 0.1/s 0.75
set_option 1.27k 0.1/s 0.74
__ SELECT and Sort _____________________________________________________
Scan 1.68k 0.2/s %SELECT: 3.85
Range 27 0.0/s 0.06
Full join 7 0.0/s 0.02
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 1.45k 0.1/s
Sort range 1.54k 0.2/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 1.09M of 64.00M %Used: 1.70
Block Fragmnt 5.61%
Hits 29.61k 2.9/s
Inserts 4.49k 0.4/s
Insrt:Prune 4.49k:1 0.4/s
Hit:Insert 6.59:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 116.04k 11.4/s
__ Tables ______________________________________________________________
Open 102 of %Cache: 10200.
Opened 8.61k 0.8/s
__ Connections _________________________________________________________
Max used 30 of 100 %Max: 30.00
Total 18.15k 1.8/s
__ Created Temp ________________________________________________________
Disk table 1.11k 0.1/s
Table 1.52k 0.1/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 6
Cached 24 of 64 %Hit: 99.83
Created 30 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 1 0.0/s
Connects 9 0.0/s
__ Bytes _______________________________________________________________
Sent 1.72G 168.3k/s
Received 166.50M 16.3k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 71.33M of 128.00M %Used: 55.73
Read ratio 0.011
Pages
Free 3.63k %Total: 44.27
Data 3.38k 41.25 %Drty: 0.00
Misc 1186 14.48
Latched 0.00
Reads 306.40k 30.0/s
From file 3.22k 0.3/s 1.05
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 9.42k 0.9/s
Flushes 3.08k 0.3/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 3.27k 0.3/s
Writes 9.10k 0.9/s
fsync 7.85k 0.8/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 132 0.0/s
Read 3.25k 0.3/s
Written 3.08k 0.3/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 424.16k 41.6/s
Updated 1.21k 0.1/s
|
