|
Mysql status
MySQL 10.1.48-MariaDB-0 uptime 5 11:41:48 Mon Jul 26 14:10:01 2021
__ Key _________________________________________________________________
Buffer used 11.18M of 128.00M %Used: 8.74
Current 24.85M %Usage: 19.41
Write ratio 0.523
Read ratio 0.033
__ Questions ___________________________________________________________
Total 2.76M 5.8/s
DMS 1.81M 3.8/s %Total: 65.48
-Unknown 848.06k 1.8/s 30.74
QC Hits 842.34k 1.8/s 30.53
Com_ 756.51k 1.6/s 27.42
COM_QUIT 201.61k 0.4/s 7.31
Slow 334 0.0/s 0.01 %DMS: 0.02
DMS 1.81M 3.8/s 65.48
SELECT 1.60M 3.4/s 57.82 88.30
UPDATE 141.02k 0.3/s 5.11 7.81
INSERT 45.86k 0.1/s 1.66 2.54
DELETE 23.64k 0.0/s 0.86 1.31
REPLACE 801 0.0/s 0.03 0.04
Com_ 756.51k 1.6/s 27.42
set_option 362.21k 0.8/s 13.13
change_db 259.39k 0.5/s 9.40
show_fields 61.41k 0.1/s 2.23
__ SELECT and Sort _____________________________________________________
Scan 343.88k 0.7/s %SELECT: 21.55
Range 56.27k 0.1/s 3.53
Full join 2.05k 0.0/s 0.13
Range check 0 0/s 0.00
Full rng join 10 0.0/s 0.00
Sort scan 66.66k 0.1/s
Sort range 10.98k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 32.05M of 64.00M %Used: 50.07
Block Fragmnt 3.98%
Hits 842.34k 1.8/s
Inserts 469.20k 1.0/s
Insrt:Prune 469.20k:1 1.0/s
Hit:Insert 1.80:1
__ Table Locks _________________________________________________________
Waited 190 0.0/s %Total: 0.02
Immediate 1.23M 2.6/s
__ Tables ______________________________________________________________
Open 217 of %Cache: 21700.
Opened 134.12k 0.3/s
__ Connections _________________________________________________________
Max used 54 of 200 %Max: 27.00
Total 201.68k 0.4/s
__ Created Temp ________________________________________________________
Disk table 161.55k 0.3/s
Table 249.04k 0.5/s
File 6 0.0/s
__ Threads _____________________________________________________________
Running 1 of 1
Cached 53 of 64 %Hit: 99.97
Created 54 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 135 0.0/s
Connects 1.05k 0.0/s
__ Bytes _______________________________________________________________
Sent 32.84G 69.3k/s
Received 468.34M 987.8/s
__ InnoDB Buffer Pool __________________________________________________
Usage 52.23M of 127.98M %Used: 40.81
Read ratio 0.000
Pages
Free 4.85k %Total: 59.19
Data 3.32k 40.56 %Drty: 0.00
Misc 21 0.26
Latched 0.00
Reads 170.09M 358.8/s
From file 3.04k 0.0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 34.38k 0.1/s
Flushes 11.94k 0.0/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 3.39k 0.0/s
Writes 18.50k 0.0/s
fsync 7.73k 0.0/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 57 0.0/s
Read 3.27k 0.0/s
Written 11.94k 0.0/s
Rows
Deleted 2 0.0/s
Inserted 86 0.0/s
Read 8.70M 18.4/s
Updated 4.06k 0.0/s
|
