|
Mysql status
MySQL 10.1.48-MariaDB-0 uptime 3 9:18:10 Thu Sep 23 22:00:02 2021
__ Key _________________________________________________________________
Buffer used 5.58M of 128.00M %Used: 4.36
Current 25.03M %Usage: 19.55
Write ratio 0.558
Read ratio 0.024
__ Questions ___________________________________________________________
Total 1.89M 6.5/s
DMS 1.33M 4.6/s %Total: 70.46
-Unknown 643.26k 2.2/s 33.98
QC Hits 628.02k 2.1/s 33.17
Com_ 439.63k 1.5/s 23.22
COM_QUIT 134.87k 0.5/s 7.12
Slow 54 0.0/s 0.00 %DMS: 0.00
DMS 1.33M 4.6/s 70.46
SELECT 1.14M 3.9/s 60.39 85.71
UPDATE 122.48k 0.4/s 6.47 9.18
INSERT 44.79k 0.2/s 2.37 3.36
DELETE 22.95k 0.1/s 1.21 1.72
REPLACE 413 0.0/s 0.02 0.03
Com_ 439.63k 1.5/s 23.22
set_option 198.69k 0.7/s 10.50
change_db 159.71k 0.5/s 8.44
show_fields 31.27k 0.1/s 1.65
__ SELECT and Sort _____________________________________________________
Scan 186.48k 0.6/s %SELECT: 16.31
Range 47.32k 0.2/s 4.14
Full join 1.17k 0.0/s 0.10
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 39.30k 0.1/s
Sort range 8.83k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 33.76M of 64.00M %Used: 52.75
Block Fragmnt 3.46%
Hits 628.02k 2.1/s
Inserts 364.90k 1.2/s
Insrt:Prune 364.90k:1 1.2/s
Hit:Insert 1.72:1
__ Table Locks _________________________________________________________
Waited 167 0.0/s %Total: 0.02
Immediate 919.93k 3.1/s
__ Tables ______________________________________________________________
Open 200 of %Cache: 20000.
Opened 72.32k 0.2/s
__ Connections _________________________________________________________
Max used 13 of 200 %Max: 6.50
Total 134.87k 0.5/s
__ Created Temp ________________________________________________________
Disk table 85.14k 0.3/s
Table 131.21k 0.4/s
File 6 0.0/s
__ Threads _____________________________________________________________
Running 1 of 3
Cached 10 of 64 %Hit: 99.99
Created 13 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 0 0/s
Connects 460 0.0/s
__ Bytes _______________________________________________________________
Sent 18.61G 63.6k/s
Received 362.35M 1.2k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 55.25M of 127.98M %Used: 43.17
Read ratio 0.000
Pages
Free 4.66k %Total: 56.83
Data 3.52k 42.91 %Drty: 0.03
Misc 21 0.26
Latched 0.00
Reads 107.06M 365.8/s
From file 3.17k 0.0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 3.63k 0.0/s
Flushes 1.41k 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.62k 0.0/s
Writes 2.23k 0.0/s
fsync 963 0.0/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 16 0.0/s
Read 3.50k 0.0/s
Written 1.41k 0.0/s
Rows
Deleted 0 0/s
Inserted 44 0.0/s
Read 5.41M 18.5/s
Updated 389 0.0/s
|
