|
Mysql status
MySQL 10.1.48-MariaDB-0 uptime 10 13:53:36 Thu Apr 15 12:00:02 2021
__ Key _________________________________________________________________
Buffer used 6.03M of 128.00M %Used: 4.71
Current 25.13M %Usage: 19.63
Write ratio 0.542
Read ratio 0.022
__ Questions ___________________________________________________________
Total 6.40M 7.0/s
DMS 4.52M 4.9/s %Total: 70.61
-Unknown 2.18M 2.4/s 34.02
QC Hits 2.15M 2.4/s 33.55
Com_ 1.51M 1.6/s 23.54
COM_QUIT 404.57k 0.4/s 6.32
Slow 133 0.0/s 0.00 %DMS: 0.00
DMS 4.52M 4.9/s 70.61
SELECT 3.87M 4.2/s 60.49 85.67
UPDATE 431.42k 0.5/s 6.74 9.54
INSERT 137.04k 0.1/s 2.14 3.03
DELETE 76.05k 0.1/s 1.19 1.68
REPLACE 3.33k 0.0/s 0.05 0.07
Com_ 1.51M 1.6/s 23.54
set_option 726.28k 0.8/s 11.35
change_db 510.04k 0.6/s 7.97
show_fields 115.05k 0.1/s 1.80
__ SELECT and Sort _____________________________________________________
Scan 645.76k 0.7/s %SELECT: 16.67
Range 170.63k 0.2/s 4.41
Full join 4.73k 0.0/s 0.12
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 118.00k 0.1/s
Sort range 25.96k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 32.00M of 64.00M %Used: 50.00
Block Fragmnt 2.85%
Hits 2.15M 2.4/s
Inserts 1.21M 1.3/s
Insrt:Prune 1.21M:1 1.3/s
Hit:Insert 1.78:1
__ Table Locks _________________________________________________________
Waited 215 0.0/s %Total: 0.01
Immediate 3.07M 3.4/s
__ Tables ______________________________________________________________
Open 212 of %Cache: 21200.
Opened 242.79k 0.3/s
__ Connections _________________________________________________________
Max used 51 of 200 %Max: 25.50
Total 404.58k 0.4/s
__ Created Temp ________________________________________________________
Disk table 292.40k 0.3/s
Table 457.82k 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.47k 0.0/s
__ Bytes _______________________________________________________________
Sent 62.80G 68.7k/s
Received 1.19G 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 327.61M 358.4/s
From file 4.43k 0.0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 5.60k 0.0/s
Flushes 2.19k 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.62k 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.19k 0.0/s
Rows
Deleted 6 0.0/s
Inserted 93 0.0/s
Read 13.36M 14.6/s
Updated 515 0.0/s
|
