|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 0 8:19:57 Thu Nov 21 10:20:01 2024
__ Key _________________________________________________________________
Buffer used 5.02M of 32.00M %Used: 15.68
Current 7.67M %Usage: 23.97
Write ratio 1.000
Read ratio 0.001
__ Questions ___________________________________________________________
Total 605.15k 20.2/s
DMS 475.63k 15.9/s %Total: 78.60
Com_ 105.74k 3.5/s 17.47
-Unknown 64.17k 2.1/s 10.60
QC Hits 57.25k 1.9/s 9.46
COM_QUIT 30.70k 1.0/s 5.07
Slow 5 0.0/s 0.00 %DMS: 0.00
DMS 475.63k 15.9/s 78.60
INSERT 351.86k 11.7/s 58.14 73.98
SELECT 119.96k 4.0/s 19.82 25.22
UPDATE 3.81k 0.1/s 0.63 0.80
DELETE 10 0.0/s 0.00 0.00
REPLACE 0 0/s 0.00 0.00
Com_ 105.74k 3.5/s 17.47
set_option 48.11k 1.6/s 7.95
change_db 31.74k 1.1/s 5.24
show_create 9.39k 0.3/s 1.55
__ SELECT and Sort _____________________________________________________
Scan 35.86k 1.2/s %SELECT: 29.90
Range 42 0.0/s 0.04
Full join 8 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 1.83k 0.1/s
Sort range 10.61k 0.4/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 1.79M of 64.00M %Used: 2.80
Block Fragmnt 4.40%
Hits 57.25k 1.9/s
Inserts 16.18k 0.5/s
Insrt:Prune 16.18k:1 0.5/s
Hit:Insert 3.54:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 399.71k 13.3/s
__ Tables ______________________________________________________________
Open 122 of %Cache: 12200.
Opened 23.87k 0.8/s
__ Connections _________________________________________________________
Max used 9 of 100 %Max: 9.00
Total 30.70k 1.0/s
__ Created Temp ________________________________________________________
Disk table 19.19k 0.6/s
Table 31.78k 1.1/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 4
Cached 5 of 64 %Hit: 99.97
Created 9 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 1 0.0/s
Connects 61 0.0/s
__ Bytes _______________________________________________________________
Sent 5.31G 177.1k/s
Received 588.36M 19.6k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 109.75M of 128.00M %Used: 85.74
Read ratio 0.008
Pages
Free 1.17k %Total: 14.26
Data 6.52k 79.63 %Drty: 0.00
Misc 501 6.12
Latched 0.00
Reads 695.67k 23.2/s
From file 5.47k 0.2/s 0.79
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 16.22k 0.5/s
Flushes 6.52k 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.46k 0.2/s
Writes 19.85k 0.7/s
fsync 17.39k 0.6/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 131 0.0/s
Read 6.39k 0.2/s
Written 6.52k 0.2/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 1.04M 34.6/s
Updated 2.15k 0.1/s
|
