|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 4 5:47:11 Fri Jun 9 19:00:01 2023
__ Key _________________________________________________________________
Buffer used 6.30M of 32.00M %Used: 19.69
Current 5.89M %Usage: 18.40
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 8.89M 24.3/s
DMS 8.43M 23.0/s %Total: 94.83
Com_ 593.92k 1.6/s 6.68
-Unknown 467.51k 1.3/s 5.26
QC Hits 268.13k 0.7/s 3.02
COM_QUIT 64.77k 0.2/s 0.73
Slow 17 0.0/s 0.00 %DMS: 0.00
DMS 8.43M 23.0/s 94.83
INSERT 7.83M 21.4/s 88.08 92.88
SELECT 527.31k 1.4/s 5.93 6.25
UPDATE 71.90k 0.2/s 0.81 0.85
DELETE 1.08k 0.0/s 0.01 0.01
REPLACE 2 0.0/s 0.00 0.00
Com_ 593.92k 1.6/s 6.68
set_option 217.18k 0.6/s 2.44
change_db 90.18k 0.2/s 1.01
stmt_execut 76.95k 0.2/s 0.87
__ SELECT and Sort _____________________________________________________
Scan 176.46k 0.5/s %SELECT: 33.46
Range 5.31k 0.0/s 1.01
Full join 18 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 24.11k 0.1/s
Sort range 12.74k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 2.99M of 64.00M %Used: 4.68
Block Fragmnt 4.02%
Hits 268.13k 0.7/s
Inserts 79.25k 0.2/s
Insrt:Prune 79.25k:1 0.2/s
Hit:Insert 3.38:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 8.03M 21.9/s
__ Tables ______________________________________________________________
Open 104 of %Cache: 10400.
Opened 76.51k 0.2/s
__ Connections _________________________________________________________
Max used 12 of 100 %Max: 12.00
Total 64.78k 0.2/s
__ Created Temp ________________________________________________________
Disk table 93.40k 0.3/s
Table 152.36k 0.4/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 8 of 7
Cached 3 of 64 %Hit: 99.98
Created 13 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 10 0.0/s
Connects 6.39k 0.0/s
__ Bytes _______________________________________________________________
Sent 33.59G 91.7k/s
Received 11.05G 30.2k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 93.36M of 128.00M %Used: 72.94
Read ratio 0.000
Pages
Free 2.22k %Total: 27.06
Data 5.30k 64.67 %Drty: 0.00
Misc 677 8.26
Latched 0.00
Reads 39.33M 107.3/s
From file 4.52k 0.0/s 0.01
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 2.50M 6.8/s
Flushes 267.11k 0.7/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 1 0.0/s
Current 0
Time acquiring
Total 7 ms
Average 7 ms
Max 7 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 4.80k 0.0/s
Writes 468.52k 1.3/s
fsync 271.48k 0.7/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 566 0.0/s
Read 4.73k 0.0/s
Written 267.11k 0.7/s
Rows
Deleted 18.10k 0.0/s
Inserted 19.94k 0.1/s
Read 26.79M 73.1/s
Updated 276.44k 0.8/s
|
