|
Mysql status
MySQL 10.1.48-MariaDB-0 uptime 10 15:3:35 Thu Apr 15 13:10:01 2021
__ Key _________________________________________________________________
Buffer used 6.03M of 128.00M %Used: 4.71
Current 24.76M %Usage: 19.34
Write ratio 0.542
Read ratio 0.022
__ Questions ___________________________________________________________
Total 6.43M 7.0/s
DMS 4.55M 5.0/s %Total: 70.68
-Unknown 2.19M 2.4/s 34.05
QC Hits 2.16M 2.4/s 33.58
Com_ 1.51M 1.6/s 23.47
COM_QUIT 406.65k 0.4/s 6.32
Slow 133 0.0/s 0.00 %DMS: 0.00
DMS 4.55M 5.0/s 70.68
SELECT 3.89M 4.2/s 60.52 85.63
UPDATE 435.13k 0.5/s 6.76 9.57
INSERT 138.26k 0.2/s 2.15 3.04
DELETE 76.69k 0.1/s 1.19 1.69
REPLACE 3.34k 0.0/s 0.05 0.07
Com_ 1.51M 1.6/s 23.47
set_option 727.28k 0.8/s 11.30
change_db 512.17k 0.6/s 7.96
show_fields 115.09k 0.1/s 1.79
__ SELECT and Sort _____________________________________________________
Scan 647.47k 0.7/s %SELECT: 16.63
Range 172.06k 0.2/s 4.42
Full join 4.78k 0.0/s 0.12
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 118.50k 0.1/s
Sort range 26.01k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 25.52M of 64.00M %Used: 39.87
Block Fragmnt 3.26%
Hits 2.16M 2.4/s
Inserts 1.22M 1.3/s
Insrt:Prune 1.22M:1 1.3/s
Hit:Insert 1.78:1
__ Table Locks _________________________________________________________
Waited 217 0.0/s %Total: 0.01
Immediate 3.10M 3.4/s
__ Tables ______________________________________________________________
Open 189 of %Cache: 18900.
Opened 242.98k 0.3/s
__ Connections _________________________________________________________
Max used 51 of 200 %Max: 25.50
Total 406.65k 0.4/s
__ Created Temp ________________________________________________________
Disk table 292.69k 0.3/s
Table 458.27k 0.5/s
File 6 0.0/s
__ Threads _____________________________________________________________
Running 1 of 2
Cached 50 of 64 %Hit: 99.99
Created 52 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 0 0/s
Connects 3.48k 0.0/s
__ Bytes _______________________________________________________________
Sent 62.88G 68.5k/s
Received 1.20G 1.3k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 77.20M of 127.98M %Used: 60.32
Read ratio 0.000
Pages
Free 3.25k %Total: 39.68
Data 4.92k 60.05 %Drty: 0.00
Misc 22 0.27
Latched 0.00
Reads 329.07M 358.4/s
From file 4.43k 0.0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 5.64k 0.0/s
Flushes 2.21k 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.03k 0.0/s
Writes 3.65k 0.0/s
fsync 1.71k 0.0/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 8 0.0/s
Read 4.91k 0.0/s
Written 2.21k 0.0/s
Rows
Deleted 6 0.0/s
Inserted 96 0.0/s
Read 13.40M 14.6/s
Updated 517 0.0/s
|
