|
Mysql status
MySQL 10.1.48-MariaDB-0 uptime 26 18:0:8 Sat Nov 27 16:30:02 2021
__ Key _________________________________________________________________
Buffer used 7.21M of 128.00M %Used: 5.64
Current 26.25M %Usage: 20.51
Write ratio 0.564
Read ratio 0.021
__ Questions ___________________________________________________________
Total 17.52M 7.6/s
DMS 12.58M 5.4/s %Total: 71.80
-Unknown 6.45M 2.8/s 36.80
QC Hits 6.35M 2.7/s 36.25
Com_ 3.92M 1.7/s 22.38
COM_QUIT 1.12M 0.5/s 6.38
Slow 1.31k 0.0/s 0.01 %DMS: 0.01
DMS 12.58M 5.4/s 71.80
SELECT 10.86M 4.7/s 62.01 86.37
UPDATE 1.09M 0.5/s 6.24 8.70
INSERT 408.65k 0.2/s 2.33 3.25
DELETE 208.85k 0.1/s 1.19 1.66
REPLACE 3.87k 0.0/s 0.02 0.03
Com_ 3.92M 1.7/s 22.38
set_option 1.82M 0.8/s 10.41
change_db 1.41M 0.6/s 8.06
show_fields 278.48k 0.1/s 1.59
__ SELECT and Sort _____________________________________________________
Scan 1.70M 0.7/s %SELECT: 15.61
Range 497.75k 0.2/s 4.58
Full join 9.17k 0.0/s 0.08
Range check 0 0/s 0.00
Full rng join 12 0.0/s 0.00
Sort scan 348.18k 0.2/s
Sort range 65.00k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 35.92M of 64.00M %Used: 56.12
Block Fragmnt 3.12%
Hits 6.35M 2.7/s
Inserts 3.22M 1.4/s
Insrt:Prune 248.60:1 1.4/s
Hit:Insert 1.97:1
__ Table Locks _________________________________________________________
Waited 961 0.0/s %Total: 0.01
Immediate 8.30M 3.6/s
__ Tables ______________________________________________________________
Open 223 of %Cache: 22300.
Opened 593.63k 0.3/s
__ Connections _________________________________________________________
Max used 43 of 200 %Max: 21.50
Total 1.12M 0.5/s
__ Created Temp ________________________________________________________
Disk table 767.43k 0.3/s
Table 1.19M 0.5/s
File 6 0.0/s
__ Threads _____________________________________________________________
Running 1 of 3
Cached 40 of 64 %Hit: 100
Created 43 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 5 0.0/s
Connects 4.97k 0.0/s
__ Bytes _______________________________________________________________
Sent 162.35G 70.2k/s
Received 3.39G 1.5k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 62.56M of 127.98M %Used: 48.88
Read ratio 0.000
Pages
Free 4.19k %Total: 51.12
Data 3.98k 48.60 %Drty: 0.00
Misc 23 0.28
Latched 0.00
Reads 845.80M 366.0/s
From file 3.53k 0.0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 29.47k 0.0/s
Flushes 12.33k 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 4.01k 0.0/s
Writes 19.57k 0.0/s
fsync 8.66k 0.0/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 91 0.0/s
Read 3.89k 0.0/s
Written 12.33k 0.0/s
Rows
Deleted 0 0/s
Inserted 440 0.0/s
Read 50.87M 22.0/s
Updated 3.06k 0.0/s
|
