|
Mysql status
MySQL 10.1.48-MariaDB-0 uptime 4 12:52:30 Fri Jun 18 12:50:02 2021
__ Key _________________________________________________________________
Buffer used 6.07M of 128.00M %Used: 4.74
Current 23.86M %Usage: 18.64
Write ratio 0.551
Read ratio 0.022
__ Questions ___________________________________________________________
Total 2.80M 7.1/s
DMS 1.94M 5.0/s %Total: 69.46
-Unknown 889.99k 2.3/s 31.81
QC Hits 876.95k 2.2/s 31.34
Com_ 680.92k 1.7/s 24.33
COM_QUIT 186.63k 0.5/s 6.67
Slow 93 0.0/s 0.00 %DMS: 0.00
DMS 1.94M 5.0/s 69.46
SELECT 1.65M 4.2/s 58.87 84.75
UPDATE 193.52k 0.5/s 6.92 9.96
INSERT 65.81k 0.2/s 2.35 3.39
DELETE 36.24k 0.1/s 1.30 1.86
REPLACE 819 0.0/s 0.03 0.04
Com_ 680.92k 1.7/s 24.33
set_option 325.22k 0.8/s 11.62
change_db 232.59k 0.6/s 8.31
show_fields 52.35k 0.1/s 1.87
__ SELECT and Sort _____________________________________________________
Scan 309.31k 0.8/s %SELECT: 18.78
Range 68.77k 0.2/s 4.17
Full join 2.25k 0.0/s 0.14
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 54.32k 0.1/s
Sort range 11.77k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 26.14M of 64.00M %Used: 40.85
Block Fragmnt 0.11%
Hits 876.95k 2.2/s
Inserts 516.58k 1.3/s
Insrt:Prune 516.58k:1 1.3/s
Hit:Insert 1.70:1
__ Table Locks _________________________________________________________
Waited 1.29k 0.0/s %Total: 0.10
Immediate 1.36M 3.5/s
__ Tables ______________________________________________________________
Open 624 of %Cache: 62400.
Opened 116.87k 0.3/s
__ Connections _________________________________________________________
Max used 52 of 200 %Max: 26.00
Total 186.64k 0.5/s
__ Created Temp ________________________________________________________
Disk table 142.71k 0.4/s
Table 222.10k 0.6/s
File 6 0.0/s
__ Threads _____________________________________________________________
Running 1 of 3
Cached 49 of 64 %Hit: 99.97
Created 52 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 25 0.0/s
Connects 916 0.0/s
__ Bytes _______________________________________________________________
Sent 28.17G 71.9k/s
Received 514.53M 1.3k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 78.30M of 127.98M %Used: 61.18
Read ratio 0.000
Pages
Free 3.18k %Total: 38.82
Data 4.98k 60.85 %Drty: 0.00
Misc 27 0.33
Latched 0.00
Reads 143.91M 367.2/s
From file 4.51k 0.0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 996 0.0/s
Flushes 519 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 5.11k 0.0/s
Writes 972 0.0/s
fsync 551 0.0/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 0 0/s
Read 4.98k 0.0/s
Written 519 0.0/s
Rows
Deleted 0 0/s
Inserted 36 0.0/s
Read 9.59M 24.5/s
Updated 77 0.0/s
|
