|
Mysql status
MySQL 10.1.48-MariaDB-0 uptime 5 13:11:48 Mon Jul 26 15:40:01 2021
__ Key _________________________________________________________________
Buffer used 11.18M of 128.00M %Used: 8.74
Current 24.82M %Usage: 19.39
Write ratio 0.524
Read ratio 0.033
__ Questions ___________________________________________________________
Total 2.79M 5.8/s
DMS 1.83M 3.8/s %Total: 65.55
-Unknown 857.89k 1.8/s 30.79
QC Hits 852.14k 1.8/s 30.59
Com_ 760.74k 1.6/s 27.31
COM_QUIT 204.67k 0.4/s 7.35
Slow 334 0.0/s 0.01 %DMS: 0.02
DMS 1.83M 3.8/s 65.55
SELECT 1.61M 3.4/s 57.88 88.29
UPDATE 142.69k 0.3/s 5.12 7.81
INSERT 46.44k 0.1/s 1.67 2.54
DELETE 23.92k 0.0/s 0.86 1.31
REPLACE 803 0.0/s 0.03 0.04
Com_ 760.74k 1.6/s 27.31
set_option 362.97k 0.8/s 13.03
change_db 262.73k 0.5/s 9.43
show_fields 61.45k 0.1/s 2.21
__ SELECT and Sort _____________________________________________________
Scan 346.56k 0.7/s %SELECT: 21.49
Range 57.01k 0.1/s 3.54
Full join 2.07k 0.0/s 0.13
Range check 0 0/s 0.00
Full rng join 10 0.0/s 0.00
Sort scan 67.68k 0.1/s
Sort range 11.12k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 31.97M of 64.00M %Used: 49.96
Block Fragmnt 0.66%
Hits 852.14k 1.8/s
Inserts 475.80k 1.0/s
Insrt:Prune 475.80k:1 1.0/s
Hit:Insert 1.79:1
__ Table Locks _________________________________________________________
Waited 190 0.0/s %Total: 0.02
Immediate 1.24M 2.6/s
__ Tables ______________________________________________________________
Open 198 of %Cache: 19800.
Opened 134.32k 0.3/s
__ Connections _________________________________________________________
Max used 54 of 200 %Max: 27.00
Total 204.74k 0.4/s
__ Created Temp ________________________________________________________
Disk table 162.21k 0.3/s
Table 249.97k 0.5/s
File 6 0.0/s
__ Threads _____________________________________________________________
Running 2 of 2
Cached 52 of 64 %Hit: 99.97
Created 54 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 152 0.0/s
Connects 1.06k 0.0/s
__ Bytes _______________________________________________________________
Sent 32.94G 68.7k/s
Received 473.85M 988.2/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 172.01M 358.7/s
From file 3.04k 0.0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 34.39k 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.52k 0.0/s
fsync 7.74k 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.79M 18.3/s
Updated 4.07k 0.0/s
|
