|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 0 2:39:56 Fri Apr 4 04:40:01 2025
__ Key _________________________________________________________________
Buffer used 1.64M of 32.00M %Used: 5.13
Current 7.12M %Usage: 22.24
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 120.51k 12.6/s
DMS 106.69k 11.1/s %Total: 88.53
COM_QUIT 10.65k 1.1/s 8.84
-Unknown 10.04k 1.0/s 8.33
Com_ 6.63k 0.7/s 5.50
QC Hits 6.59k 0.7/s 5.46
Slow 1 0.0/s 0.00 %DMS: 0.00
DMS 106.69k 11.1/s 88.53
INSERT 86.08k 9.0/s 71.43 80.69
SELECT 18.79k 2.0/s 15.59 17.62
UPDATE 1.80k 0.2/s 1.49 1.69
DELETE 15 0.0/s 0.01 0.01
REPLACE 0 0/s 0.00 0.00
Com_ 6.63k 0.7/s 5.50
change_db 2.49k 0.3/s 2.06
stmt_execut 1.15k 0.1/s 0.96
stmt_prepar 1.14k 0.1/s 0.95
__ SELECT and Sort _____________________________________________________
Scan 1.20k 0.1/s %SELECT: 6.37
Range 20 0.0/s 0.11
Full join 4 0.0/s 0.02
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 498 0.1/s
Sort range 1.10k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 916.21k of 64.00M %Used: 1.40
Block Fragmnt 0.23%
Hits 6.59k 0.7/s
Inserts 3.43k 0.4/s
Insrt:Prune 3.43k:1 0.4/s
Hit:Insert 1.92:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 100.68k 10.5/s
__ Tables ______________________________________________________________
Open 52 of %Cache: 5200.0
Opened 8.52k 0.9/s
__ Connections _________________________________________________________
Max used 9 of 100 %Max: 9.00
Total 10.65k 1.1/s
__ Created Temp ________________________________________________________
Disk table 372 0.0/s
Table 666 0.1/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 2
Cached 7 of 64 %Hit: 99.92
Created 9 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 0 0/s
Connects 2 0.0/s
__ Bytes _______________________________________________________________
Sent 218.17M 22.7k/s
Received 144.70M 15.1k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 71.27M of 128.00M %Used: 55.68
Read ratio 0.013
Pages
Free 3.63k %Total: 44.32
Data 3.38k 41.21 %Drty: 0.00
Misc 1185 14.47
Latched 0.00
Reads 255.84k 26.7/s
From file 3.22k 0.3/s 1.26
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 8.69k 0.9/s
Flushes 2.70k 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 8.02k 0.8/s
fsync 6.89k 0.7/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 131 0.0/s
Read 3.25k 0.3/s
Written 2.70k 0.3/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 379.47k 39.5/s
Updated 1.09k 0.1/s
|
