|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 0 22:19:58 Thu Apr 3 00:20:01 2025
__ Key _________________________________________________________________
Buffer used 4.80M of 32.00M %Used: 15.01
Current 7.51M %Usage: 23.46
Write ratio 1.000
Read ratio 0.001
__ Questions ___________________________________________________________
Total 1.33M 16.6/s
DMS 1.15M 14.3/s %Total: 86.20
-Unknown 306.68k 3.8/s 23.03
QC Hits 285.61k 3.6/s 21.45
Com_ 156.17k 1.9/s 11.73
COM_QUIT 48.65k 0.6/s 3.65
Slow 4 0.0/s 0.00 %DMS: 0.00
DMS 1.15M 14.3/s 86.20
INSERT 766.07k 9.5/s 57.52 66.73
SELECT 370.36k 4.6/s 27.81 32.26
UPDATE 11.46k 0.1/s 0.86 1.00
DELETE 83 0.0/s 0.01 0.01
REPLACE 1 0.0/s 0.00 0.00
Com_ 156.17k 1.9/s 11.73
set_option 64.55k 0.8/s 4.85
change_db 50.17k 0.6/s 3.77
show_create 9.79k 0.1/s 0.74
__ SELECT and Sort _____________________________________________________
Scan 44.83k 0.6/s %SELECT: 12.10
Range 234 0.0/s 0.06
Full join 22 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 11.08k 0.1/s
Sort range 12.14k 0.2/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 4.45M of 64.00M %Used: 6.95
Block Fragmnt 2.17%
Hits 285.61k 3.6/s
Inserts 34.16k 0.4/s
Insrt:Prune 34.16k:1 0.4/s
Hit:Insert 8.36:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 887.50k 11.0/s
__ Tables ______________________________________________________________
Open 132 of %Cache: 13200.
Opened 25.02k 0.3/s
__ Connections _________________________________________________________
Max used 12 of 100 %Max: 12.00
Total 48.65k 0.6/s
__ Created Temp ________________________________________________________
Disk table 27.80k 0.3/s
Table 42.80k 0.5/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 1
Cached 11 of 64 %Hit: 99.98
Created 12 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 1 0.0/s
Connects 105 0.0/s
__ Bytes _______________________________________________________________
Sent 6.57G 81.7k/s
Received 1.36G 16.9k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 106.89M of 128.00M %Used: 83.51
Read ratio 0.003
Pages
Free 1.35k %Total: 16.49
Data 6.33k 77.33 %Drty: 0.00
Misc 506 6.18
Latched 0.00
Reads 1.72M 21.4/s
From file 5.29k 0.1/s 0.31
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 48.52k 0.6/s
Flushes 18.64k 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.28k 0.1/s
Writes 57.22k 0.7/s
fsync 50.18k 0.6/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 131 0.0/s
Read 6.20k 0.1/s
Written 18.64k 0.2/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 2.30M 28.7/s
Updated 6.59k 0.1/s
|
