|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 32 14:4:53 Fri Dec 1 11:10:01 2023
__ Key _________________________________________________________________
Buffer used 6.35M of 32.00M %Used: 19.84
Current 8.65M %Usage: 27.02
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 70.43M 25.0/s
DMS 65.94M 23.4/s %Total: 93.62
-Unknown 4.76M 1.7/s 6.76
Com_ 4.34M 1.5/s 6.17
QC Hits 4.05M 1.4/s 5.75
COM_QUIT 856.03k 0.3/s 1.22
Slow 140 0.0/s 0.00 %DMS: 0.00
DMS 65.94M 23.4/s 93.62
INSERT 59.24M 21.0/s 84.12 89.85
SELECT 6.33M 2.2/s 8.98 9.59
UPDATE 367.55k 0.1/s 0.52 0.56
DELETE 646 0.0/s 0.00 0.00
REPLACE 37 0.0/s 0.00 0.00
Com_ 4.34M 1.5/s 6.17
set_option 1.83M 0.7/s 2.61
change_db 1.15M 0.4/s 1.63
show_create 324.69k 0.1/s 0.46
__ SELECT and Sort _____________________________________________________
Scan 1.43M 0.5/s %SELECT: 22.55
Range 6.25k 0.0/s 0.10
Full join 310 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 223.94k 0.1/s
Sort range 285.18k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 947.89k of 64.00M %Used: 1.45
Block Fragmnt 0.84%
Hits 4.05M 1.4/s
Inserts 864.71k 0.3/s
Insrt:Prune 864.71k:1 0.3/s
Hit:Insert 4.69:1
__ Table Locks _________________________________________________________
Waited 2 0.0/s %Total: 0.00
Immediate 61.65M 21.9/s
__ Tables ______________________________________________________________
Open 101 of %Cache: 10100.
Opened 555.72k 0.2/s
__ Connections _________________________________________________________
Max used 33 of 100 %Max: 33.00
Total 856.08k 0.3/s
__ Created Temp ________________________________________________________
Disk table 793.94k 0.3/s
Table 1.27M 0.4/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 3
Cached 10 of 64 %Hit: 99.99
Created 53 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 87 0.0/s
Connects 28.35k 0.0/s
__ Bytes _______________________________________________________________
Sent 264.75G 94.0k/s
Received 78.53G 27.9k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 102.80M of 128.00M %Used: 80.31
Read ratio 0.000
Pages
Free 1.61k %Total: 19.69
Data 6.03k 73.65 %Drty: 0.00
Misc 546 6.67
Latched 0.00
Reads 79.10M 28.1/s
From file 5.12k 0.0/s 0.01
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 1.77M 0.6/s
Flushes 598.28k 0.2/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 3 0.0/s
Current 0
Time acquiring
Total 51 ms
Average 17 ms
Max 27 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 5.59k 0.0/s
Writes 1.75M 0.6/s
fsync 1.52M 0.5/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 515 0.0/s
Read 5.52k 0.0/s
Written 598.28k 0.2/s
Rows
Deleted 153 0.0/s
Inserted 19.21k 0.0/s
Read 81.79M 29.0/s
Updated 214.80k 0.1/s
|
