|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 0 15:39:57 Sat Dec 14 17:40:01 2024
__ Key _________________________________________________________________
Buffer used 4.95M of 32.00M %Used: 15.46
Current 7.36M %Usage: 22.99
Write ratio 1.000
Read ratio 0.001
__ Questions ___________________________________________________________
Total 876.25k 15.5/s
DMS 749.31k 13.3/s %Total: 85.51
Com_ 113.73k 2.0/s 12.98
-Unknown 93.49k 1.7/s 10.67
QC Hits 81.61k 1.4/s 9.31
COM_QUIT 25.08k 0.4/s 2.86
Slow 7 0.0/s 0.00 %DMS: 0.00
DMS 749.31k 13.3/s 85.51
INSERT 593.62k 10.5/s 67.75 79.22
SELECT 148.28k 2.6/s 16.92 19.79
UPDATE 7.38k 0.1/s 0.84 0.99
DELETE 25 0.0/s 0.00 0.00
REPLACE 3 0.0/s 0.00 0.00
Com_ 113.73k 2.0/s 12.98
set_option 53.76k 1.0/s 6.13
change_db 26.40k 0.5/s 3.01
show_create 9.59k 0.2/s 1.09
__ SELECT and Sort _____________________________________________________
Scan 40.60k 0.7/s %SELECT: 27.38
Range 144 0.0/s 0.10
Full join 16 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 7.15k 0.1/s
Sort range 3.00k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 1.12M of 64.00M %Used: 1.75
Block Fragmnt 0.46%
Hits 81.61k 1.4/s
Inserts 15.63k 0.3/s
Insrt:Prune 15.63k:1 0.3/s
Hit:Insert 5.22:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 667.24k 11.8/s
__ Tables ______________________________________________________________
Open 139 of %Cache: 13900.
Opened 24.44k 0.4/s
__ Connections _________________________________________________________
Max used 36 of 100 %Max: 36.00
Total 25.09k 0.4/s
__ Created Temp ________________________________________________________
Disk table 24.73k 0.4/s
Table 39.25k 0.7/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 4
Cached 6 of 64 %Hit: 99.84
Created 39 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 4 0.0/s
Connects 65 0.0/s
__ Bytes _______________________________________________________________
Sent 6.05G 107.3k/s
Received 1.02G 18.1k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 108.81M of 128.00M %Used: 85.01
Read ratio 0.004
Pages
Free 1.23k %Total: 14.99
Data 6.46k 78.85 %Drty: 0.00
Misc 505 6.16
Latched 0.00
Reads 1.23M 21.8/s
From file 5.41k 0.1/s 0.44
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 32.12k 0.6/s
Flushes 12.07k 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.40k 0.1/s
Writes 37.15k 0.7/s
fsync 32.58k 0.6/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 132 0.0/s
Read 6.33k 0.1/s
Written 12.07k 0.2/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 1.73M 30.7/s
Updated 4.33k 0.1/s
|
