|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 2 5:30:50 Tue Apr 16 23:40:01 2024
__ Key _________________________________________________________________
Buffer used 5.76M of 32.00M %Used: 18.01
Current 8.04M %Usage: 25.11
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 3.88M 20.1/s
DMS 3.56M 18.5/s %Total: 91.76
-Unknown 330.66k 1.7/s 8.52
Com_ 290.90k 1.5/s 7.49
QC Hits 269.69k 1.4/s 6.95
COM_QUIT 90.02k 0.5/s 2.32
Slow 8 0.0/s 0.00 %DMS: 0.00
DMS 3.56M 18.5/s 91.76
INSERT 3.12M 16.2/s 80.39 87.61
SELECT 416.31k 2.2/s 10.73 11.69
UPDATE 24.82k 0.1/s 0.64 0.70
DELETE 49 0.0/s 0.00 0.00
REPLACE 4 0.0/s 0.00 0.00
Com_ 290.90k 1.5/s 7.49
set_option 112.87k 0.6/s 2.91
change_db 89.06k 0.5/s 2.29
show_create 19.84k 0.1/s 0.51
__ SELECT and Sort _____________________________________________________
Scan 91.28k 0.5/s %SELECT: 21.93
Range 349 0.0/s 0.08
Full join 35 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 17.01k 0.1/s
Sort range 12.89k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 1.58M of 64.00M %Used: 2.47
Block Fragmnt 0.31%
Hits 269.69k 1.4/s
Inserts 50.95k 0.3/s
Insrt:Prune 50.95k:1 0.3/s
Hit:Insert 5.29:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 3.28M 17.0/s
__ Tables ______________________________________________________________
Open 105 of %Cache: 10500.
Opened 41.94k 0.2/s
__ Connections _________________________________________________________
Max used 64 of 100 %Max: 64.00
Total 90.03k 0.5/s
__ Created Temp ________________________________________________________
Disk table 51.05k 0.3/s
Table 81.20k 0.4/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 7 of 2
Cached 52 of 64 %Hit: 99.93
Created 65 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 13 0.0/s
Connects 13.88k 0.1/s
__ Bytes _______________________________________________________________
Sent 15.75G 81.8k/s
Received 4.49G 23.3k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 112.00M of 128.00M %Used: 87.50
Read ratio 0.001
Pages
Free 1.02k %Total: 12.50
Data 6.66k 81.29 %Drty: 0.00
Misc 509 6.21
Latched 0.00
Reads 4.67M 24.2/s
From file 5.82k 0.0/s 0.12
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 115.38k 0.6/s
Flushes 41.97k 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.87k 0.0/s
Writes 122.17k 0.6/s
fsync 106.38k 0.6/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 131 0.0/s
Read 6.79k 0.0/s
Written 41.97k 0.2/s
Rows
Deleted 235 0.0/s
Inserted 6 0.0/s
Read 5.95M 30.9/s
Updated 14.74k 0.1/s
|
