|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 26 10:40:50 Sat May 11 04:50:01 2024
__ Key _________________________________________________________________
Buffer used 5.82M of 32.00M %Used: 18.19
Current 7.96M %Usage: 24.86
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 46.33M 20.3/s
DMS 42.55M 18.6/s %Total: 91.84
-Unknown 4.13M 1.8/s 8.91
Com_ 3.60M 1.6/s 7.76
QC Hits 3.50M 1.5/s 7.55
COM_QUIT 816.95k 0.4/s 1.76
Slow 96 0.0/s 0.00 %DMS: 0.00
DMS 42.55M 18.6/s 91.84
INSERT 36.93M 16.2/s 79.71 86.79
SELECT 5.32M 2.3/s 11.49 12.51
UPDATE 298.51k 0.1/s 0.64 0.70
DELETE 611 0.0/s 0.00 0.00
REPLACE 45 0.0/s 0.00 0.00
Com_ 3.60M 1.6/s 7.76
set_option 1.45M 0.6/s 3.14
change_db 1.02M 0.4/s 2.20
show_create 256.38k 0.1/s 0.55
__ SELECT and Sort _____________________________________________________
Scan 1.14M 0.5/s %SELECT: 21.50
Range 4.20k 0.0/s 0.08
Full join 260 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 192.57k 0.1/s
Sort range 243.69k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 578.77k of 64.00M %Used: 0.88
Block Fragmnt 0.88%
Hits 3.50M 1.5/s
Inserts 704.40k 0.3/s
Insrt:Prune 704.40k:1 0.3/s
Hit:Insert 4.96:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 38.93M 17.0/s
__ Tables ______________________________________________________________
Open 76 of %Cache: 7600.0
Opened 441.27k 0.2/s
__ Connections _________________________________________________________
Max used 64 of 100 %Max: 64.00
Total 817.01k 0.4/s
__ Created Temp ________________________________________________________
Disk table 639.40k 0.3/s
Table 1.02M 0.4/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 2
Cached 7 of 64 %Hit: 99.98
Created 195 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 124 0.0/s
Connects 50.29k 0.0/s
__ Bytes _______________________________________________________________
Sent 199.96G 87.5k/s
Received 53.31G 23.3k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 112.00M of 128.00M %Used: 87.50
Read ratio 0.000
Pages
Free 1.02k %Total: 12.50
Data 6.65k 81.13 %Drty: 0.00
Misc 522 6.37
Latched 0.00
Reads 56.36M 24.7/s
From file 5.86k 0.0/s 0.01
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 1.31M 0.6/s
Flushes 487.21k 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.90k 0.0/s
Writes 1.44M 0.6/s
fsync 1.25M 0.5/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 133 0.0/s
Read 6.83k 0.0/s
Written 487.21k 0.2/s
Rows
Deleted 531 0.0/s
Inserted 38 0.0/s
Read 71.36M 31.2/s
Updated 174.69k 0.1/s
|
