|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 14 9:49:36 Sat Jul 27 09:30:01 2024
__ Key _________________________________________________________________
Buffer used 5.51M of 32.00M %Used: 17.23
Current 6.24M %Usage: 19.49
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 23.86M 19.2/s
DMS 21.71M 17.4/s %Total: 91.00
-Unknown 2.74M 2.2/s 11.47
QC Hits 2.43M 2.0/s 10.20
Com_ 2.04M 1.6/s 8.54
COM_QUIT 412.29k 0.3/s 1.73
Slow 72 0.0/s 0.00 %DMS: 0.00
DMS 21.71M 17.4/s 91.00
INSERT 18.06M 14.5/s 75.68 83.17
SELECT 3.49M 2.8/s 14.63 16.08
UPDATE 162.84k 0.1/s 0.68 0.75
DELETE 265 0.0/s 0.00 0.00
REPLACE 26 0.0/s 0.00 0.00
Com_ 2.04M 1.6/s 8.54
set_option 874.39k 0.7/s 3.67
change_db 552.63k 0.4/s 2.32
show_create 147.32k 0.1/s 0.62
__ SELECT and Sort _____________________________________________________
Scan 664.64k 0.5/s %SELECT: 19.04
Range 2.84k 0.0/s 0.08
Full join 169 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 123.68k 0.1/s
Sort range 126.00k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 941.35k of 64.00M %Used: 1.44
Block Fragmnt 15.68%
Hits 2.43M 2.0/s
Inserts 391.26k 0.3/s
Insrt:Prune 391.26k:1 0.3/s
Hit:Insert 6.22:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 19.25M 15.5/s
__ Tables ______________________________________________________________
Open 127 of %Cache: 12700.
Opened 257.10k 0.2/s
__ Connections _________________________________________________________
Max used 40 of 100 %Max: 40.00
Total 412.37k 0.3/s
__ Created Temp ________________________________________________________
Disk table 372.92k 0.3/s
Table 602.44k 0.5/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 8 of 8
Cached 16 of 64 %Hit: 99.97
Created 133 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 144 0.0/s
Connects 1.12k 0.0/s
__ Bytes _______________________________________________________________
Sent 107.83G 86.6k/s
Received 26.78G 21.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.65k 81.15 %Drty: 0.00
Misc 520 6.35
Latched 0.00
Reads 28.09M 22.6/s
From file 5.63k 0.0/s 0.02
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 695.94k 0.6/s
Flushes 269.64k 0.2/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 2 0.0/s
Current 0
Time acquiring
Total 81 ms
Average 40 ms
Max 43 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 6.67k 0.0/s
Writes 816.96k 0.7/s
fsync 715.59k 0.6/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 132 0.0/s
Read 6.60k 0.0/s
Written 269.64k 0.2/s
Rows
Deleted 297 0.0/s
Inserted 0 0/s
Read 36.63M 29.4/s
Updated 95.03k 0.1/s
|
