|
Mysql status
MySQL 10.1.48-MariaDB-0 uptime 3 21:38:52 Wed May 19 00:00:03 2021
__ Key _________________________________________________________________
Buffer used 5.28M of 128.00M %Used: 4.12
Current 25.50M %Usage: 19.92
Write ratio 0.588
Read ratio 0.016
__ Questions ___________________________________________________________
Total 2.90M 8.6/s
DMS 2.19M 6.5/s %Total: 75.48
-Unknown 1.03M 3.1/s 35.54
QC Hits 1.02M 3.0/s 35.27
Com_ 569.45k 1.7/s 19.64
COM_QUIT 149.55k 0.4/s 5.16
Slow 159 0.0/s 0.01 %DMS: 0.01
DMS 2.19M 6.5/s 75.48
SELECT 1.80M 5.3/s 62.14 82.33
UPDATE 240.50k 0.7/s 8.29 10.99
INSERT 96.12k 0.3/s 3.31 4.39
DELETE 49.28k 0.1/s 1.70 2.25
REPLACE 839 0.0/s 0.03 0.04
Com_ 569.45k 1.7/s 19.64
set_option 280.85k 0.8/s 9.68
change_db 193.08k 0.6/s 6.66
show_fields 42.13k 0.1/s 1.45
__ SELECT and Sort _____________________________________________________
Scan 260.24k 0.8/s %SELECT: 14.44
Range 105.31k 0.3/s 5.84
Full join 1.42k 0.0/s 0.08
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 45.81k 0.1/s
Sort range 9.60k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 34.38M of 64.00M %Used: 53.72
Block Fragmnt 7.46%
Hits 1.02M 3.0/s
Inserts 592.82k 1.8/s
Insrt:Prune 592.82k:1 1.8/s
Hit:Insert 1.73:1
__ Table Locks _________________________________________________________
Waited 202 0.0/s %Total: 0.01
Immediate 1.60M 4.8/s
__ Tables ______________________________________________________________
Open 203 of %Cache: 20300.
Opened 85.63k 0.3/s
__ Connections _________________________________________________________
Max used 14 of 200 %Max: 7.00
Total 149.55k 0.4/s
__ Created Temp ________________________________________________________
Disk table 108.84k 0.3/s
Table 170.21k 0.5/s
File 6 0.0/s
__ Threads _____________________________________________________________
Running 1 of 3
Cached 11 of 64 %Hit: 99.99
Created 14 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 0 0/s
Connects 1.10k 0.0/s
__ Bytes _______________________________________________________________
Sent 23.61G 70.0k/s
Received 597.01M 1.8k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 76.12M of 127.98M %Used: 59.48
Read ratio 0.000
Pages
Free 3.32k %Total: 40.52
Data 4.85k 59.21 %Drty: 0.00
Misc 22 0.27
Latched 0.00
Reads 121.74M 361.1/s
From file 4.38k 0.0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 560 0.0/s
Flushes 273 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.97k 0.0/s
Writes 580 0.0/s
fsync 376 0.0/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 0 0/s
Read 4.85k 0.0/s
Written 274 0.0/s
Rows
Deleted 0 0/s
Inserted 27 0.0/s
Read 5.67M 16.8/s
Updated 41 0.0/s
|
