|
Mysql status
MySQL 10.5.28-MariaDB-0 uptime 9 16:44:10 Sat May 24 11:30:01 2025
__ Key _________________________________________________________________
Buffer used 5.44M of 16.00M %Used: 34.02
Current 3.01M %Usage: 18.84
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 17.73M 21.2/s
DMS 15.27M 18.2/s %Total: 86.16
-Unknown 6.34M 7.6/s 35.79
QC Hits 6.19M 7.4/s 34.93
Com_ 1.99M 2.4/s 11.20
COM_QUIT 620.43k 0.7/s 3.50
Slow 44 0.0/s 0.00 %DMS: 0.00
DMS 15.27M 18.2/s 86.16
INSERT 7.80M 9.3/s 44.02 51.09
SELECT 7.37M 8.8/s 41.55 48.23
UPDATE 103.15k 0.1/s 0.58 0.68
DELETE 1.17k 0.0/s 0.01 0.01
REPLACE 30 0.0/s 0.00 0.00
Com_ 1.99M 2.4/s 11.20
set_option 897.84k 1.1/s 5.07
change_db 711.44k 0.8/s 4.01
show_create 98.27k 0.1/s 0.55
__ SELECT and Sort _____________________________________________________
Scan 476.71k 0.6/s %SELECT: 6.47
Range 14.16k 0.0/s 0.19
Full join 4.10k 0.0/s 0.06
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 49.40M 59.0/s
Sort range 134.76k 0.2/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 2.31M of 16.00M %Used: 14.45
Block Fragmnt 10.30%
Hits 6.19M 7.4/s
Inserts 343.01k 0.4/s
Insrt:Prune 343.01k:1 0.4/s
Hit:Insert 18.05:1
__ Table Locks _________________________________________________________
Waited 2 0.0/s %Total: 0.00
Immediate 9.07M 10.8/s
__ Tables ______________________________________________________________
Open 261 of %Cache: 26100.
Opened 192.81k 0.2/s
__ Connections _________________________________________________________
Max used 75 of 100 %Max: 75.00
Total 620.46k 0.7/s
__ Created Temp ________________________________________________________
Disk table 254.68k 0.3/s
Table 413.80k 0.5/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 2 of 6
Cached 2 of 8 %Hit: 99.35
Created 4.02k 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 42 0.0/s
Connects 618 0.0/s
__ Bytes _______________________________________________________________
Sent 91.14G 108.8k/s
Received 14.23G 17.0k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 119.00M of 126.02M %Used: 94.43
Read ratio 0.000
Pages
Free 449 %Total: 5.57
Data 7.14k 88.53 %Drty: 4.62
Misc 476 5.90
Latched 0.00
Reads 15.47M 18.5/s
From file 5.76k 0.0/s 0.04
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 322.28k 0.4/s
Flushes 0 0/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.91k 0.0/s
Writes 100.56k 0.1/s
fsync 100.56k 0.1/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 307 0.0/s
Read 6.83k 0.0/s
Written 0 0/s
Rows
Deleted 1 0.0/s
Inserted 3 0.0/s
Read 21.15M 25.2/s
Updated 52.49k 0.1/s
|
