|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 15 0:40:50 Mon Apr 29 18:50:01 2024
__ Key _________________________________________________________________
Buffer used 5.76M of 32.00M %Used: 18.01
Current 8.03M %Usage: 25.09
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 27.13M 20.9/s
DMS 24.70M 19.0/s %Total: 91.02
-Unknown 2.75M 2.1/s 10.13
QC Hits 2.36M 1.8/s 8.71
Com_ 2.21M 1.7/s 8.16
COM_QUIT 608.12k 0.5/s 2.24
Slow 57 0.0/s 0.00 %DMS: 0.00
DMS 24.70M 19.0/s 91.02
INSERT 21.05M 16.2/s 77.57 85.22
SELECT 3.48M 2.7/s 12.82 14.09
UPDATE 170.04k 0.1/s 0.63 0.69
DELETE 364 0.0/s 0.00 0.00
REPLACE 26 0.0/s 0.00 0.00
Com_ 2.21M 1.7/s 8.16
set_option 847.52k 0.7/s 3.12
change_db 712.60k 0.5/s 2.63
show_create 147.76k 0.1/s 0.54
__ SELECT and Sort _____________________________________________________
Scan 668.23k 0.5/s %SELECT: 19.21
Range 2.49k 0.0/s 0.07
Full join 182 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 121.51k 0.1/s
Sort range 182.34k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 1.84M of 64.00M %Used: 2.88
Block Fragmnt 7.12%
Hits 2.36M 1.8/s
Inserts 453.78k 0.3/s
Insrt:Prune 453.78k:1 0.3/s
Hit:Insert 5.21:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 22.33M 17.2/s
__ Tables ______________________________________________________________
Open 103 of %Cache: 10300.
Opened 258.20k 0.2/s
__ Connections _________________________________________________________
Max used 64 of 100 %Max: 64.00
Total 608.15k 0.5/s
__ Created Temp ________________________________________________________
Disk table 376.96k 0.3/s
Table 597.57k 0.5/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 5
Cached 7 of 64 %Hit: 99.99
Created 77 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 64 0.0/s
Connects 40.95k 0.0/s
__ Bytes _______________________________________________________________
Sent 116.92G 90.0k/s
Received 30.48G 23.5k/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.66k 81.27 %Drty: 0.09
Misc 510 6.23
Latched 0.00
Reads 31.69M 24.4/s
From file 5.83k 0.0/s 0.02
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 752.42k 0.6/s
Flushes 276.72k 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.88k 0.0/s
Writes 811.92k 0.6/s
fsync 707.35k 0.5/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 133 0.0/s
Read 6.81k 0.0/s
Written 276.72k 0.2/s
Rows
Deleted 269 0.0/s
Inserted 31 0.0/s
Read 40.30M 31.0/s
Updated 99.46k 0.1/s
|
