|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 0 5:19:57 Thu Nov 21 07:20:01 2024
__ Key _________________________________________________________________
Buffer used 5.02M of 32.00M %Used: 15.68
Current 7.43M %Usage: 23.23
Write ratio 1.000
Read ratio 0.001
__ Questions ___________________________________________________________
Total 430.61k 22.4/s
DMS 318.56k 16.6/s %Total: 73.98
Com_ 93.96k 4.9/s 21.82
-Unknown 40.56k 2.1/s 9.42
QC Hits 36.21k 1.9/s 8.41
COM_QUIT 22.44k 1.2/s 5.21
Slow 5 0.0/s 0.00 %DMS: 0.00
DMS 318.56k 16.6/s 73.98
INSERT 223.91k 11.7/s 52.00 70.29
SELECT 92.32k 4.8/s 21.44 28.98
UPDATE 2.33k 0.1/s 0.54 0.73
DELETE 3 0.0/s 0.00 0.00
REPLACE 0 0/s 0.00 0.00
Com_ 93.96k 4.9/s 21.82
set_option 47.46k 2.5/s 11.02
change_db 23.51k 1.2/s 5.46
show_create 9.30k 0.5/s 2.16
__ SELECT and Sort _____________________________________________________
Scan 34.43k 1.8/s %SELECT: 37.30
Range 23 0.0/s 0.02
Full join 4 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 1.38k 0.1/s
Sort range 6.75k 0.4/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 1.37M of 64.00M %Used: 2.14
Block Fragmnt 5.32%
Hits 36.21k 1.9/s
Inserts 10.42k 0.5/s
Insrt:Prune 10.42k:1 0.5/s
Hit:Insert 3.47:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 260.67k 13.6/s
__ Tables ______________________________________________________________
Open 104 of %Cache: 10400.
Opened 23.71k 1.2/s
__ Connections _________________________________________________________
Max used 9 of 100 %Max: 9.00
Total 22.44k 1.2/s
__ Created Temp ________________________________________________________
Disk table 18.72k 1.0/s
Table 30.82k 1.6/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 2
Cached 7 of 64 %Hit: 99.96
Created 9 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 1 0.0/s
Connects 12 0.0/s
__ Bytes _______________________________________________________________
Sent 4.98G 259.2k/s
Received 378.14M 19.7k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 109.72M of 128.00M %Used: 85.72
Read ratio 0.012
Pages
Free 1.17k %Total: 14.28
Data 6.52k 79.60 %Drty: 0.00
Misc 501 6.12
Latched 0.00
Reads 445.37k 23.2/s
From file 5.47k 0.3/s 1.23
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 10.61k 0.6/s
Flushes 4.13k 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.46k 0.3/s
Writes 12.41k 0.6/s
fsync 10.81k 0.6/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 131 0.0/s
Read 6.39k 0.3/s
Written 4.13k 0.2/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 761.95k 39.7/s
Updated 1.36k 0.1/s
|
