|
Mysql status
MySQL 10.1.47-MariaDB-0 uptime 2 18:18:53 Mon Jan 25 11:50:01 2021
__ Key _________________________________________________________________
Buffer used 4.73M of 128.00M %Used: 3.69
Current 25.11M %Usage: 19.62
Write ratio 0.588
Read ratio 0.022
__ Questions ___________________________________________________________
Total 1.96M 8.2/s
DMS 1.45M 6.1/s %Total: 74.17
-Unknown 771.26k 3.2/s 39.44
QC Hits 723.94k 3.0/s 37.02
Com_ 452.70k 1.9/s 23.15
COM_QUIT 99.81k 0.4/s 5.10
Slow 37 0.0/s 0.00 %DMS: 0.00
DMS 1.45M 6.1/s 74.17
SELECT 1.22M 5.1/s 62.44 84.19
UPDATE 147.37k 0.6/s 7.54 10.16
INSERT 56.03k 0.2/s 2.86 3.86
DELETE 25.57k 0.1/s 1.31 1.76
REPLACE 397 0.0/s 0.02 0.03
Com_ 452.70k 1.9/s 23.15
set_option 207.66k 0.9/s 10.62
change_db 131.70k 0.6/s 6.73
admin_comma 46.60k 0.2/s 2.38
__ SELECT and Sort _____________________________________________________
Scan 185.25k 0.8/s %SELECT: 15.17
Range 59.45k 0.2/s 4.87
Full join 723 0.0/s 0.06
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 31.42k 0.1/s
Sort range 6.77k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 30.66M of 64.00M %Used: 47.91
Block Fragmnt 2.34%
Hits 723.94k 3.0/s
Inserts 361.03k 1.5/s
Insrt:Prune 361.03k:1 1.5/s
Hit:Insert 2.01:1
__ Table Locks _________________________________________________________
Waited 263 0.0/s %Total: 0.03
Immediate 970.06k 4.1/s
__ Tables ______________________________________________________________
Open 199 of %Cache: 19900.
Opened 64.60k 0.3/s
__ Connections _________________________________________________________
Max used 8 of 200 %Max: 4.00
Total 99.81k 0.4/s
__ Created Temp ________________________________________________________
Disk table 80.86k 0.3/s
Table 125.79k 0.5/s
File 6 0.0/s
__ Threads _____________________________________________________________
Running 1 of 1
Cached 7 of 64 %Hit: 99.99
Created 8 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 0 0/s
Connects 482 0.0/s
__ Bytes _______________________________________________________________
Sent 17.34G 72.7k/s
Received 401.70M 1.7k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 80.17M of 127.98M %Used: 62.64
Read ratio 0.000
Pages
Free 3.06k %Total: 37.36
Data 5.09k 62.14 %Drty: 0.57
Misc 41 0.50
Latched 0.00
Reads 84.84M 355.4/s
From file 4.56k 0.0/s 0.01
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 56.30k 0.2/s
Flushes 8.36k 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.37k 0.0/s
Writes 12.43k 0.1/s
fsync 4.93k 0.0/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 38 0.0/s
Read 5.05k 0.0/s
Written 8.36k 0.0/s
Rows
Deleted 2.31k 0.0/s
Inserted 971 0.0/s
Read 3.54M 14.8/s
Updated 2.31k 0.0/s
|