|
Mysql status
MySQL 10.1.47-MariaDB-0 uptime 0 3:27:37 Tue Oct 27 15:10:01 2020
__ Key _________________________________________________________________
Buffer used 3.14M of 128.00M %Used: 2.46
Current 25.00M %Usage: 19.53
Write ratio 0.565
Read ratio 0.024
__ Questions ___________________________________________________________
Total 86.42k 6.9/s
DMS 73.26k 5.9/s %Total: 84.77
-Unknown 33.13k 2.7/s 38.34
QC Hits 32.50k 2.6/s 37.61
Com_ 9.03k 0.7/s 10.44
COM_QUIT 4.77k 0.4/s 5.52
Slow 0 0/s 0.00 %DMS: 0.00
DMS 73.26k 5.9/s 84.77
SELECT 61.60k 4.9/s 71.28 84.09
UPDATE 7.51k 0.6/s 8.69 10.25
INSERT 2.50k 0.2/s 2.90 3.42
DELETE 1.61k 0.1/s 1.87 2.20
REPLACE 31 0.0/s 0.04 0.04
Com_ 9.03k 0.7/s 10.44
change_db 4.89k 0.4/s 5.66
set_option 3.20k 0.3/s 3.70
admin_comma 618 0.0/s 0.72
__ SELECT and Sort _____________________________________________________
Scan 4.06k 0.3/s %SELECT: 6.58
Range 2.57k 0.2/s 4.17
Full join 60 0.0/s 0.10
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 1.55k 0.1/s
Sort range 3.16k 0.3/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 29.13M of 64.00M %Used: 45.51
Block Fragmnt 2.21%
Hits 32.50k 2.6/s
Inserts 27.99k 2.2/s
Insrt:Prune 27.99k:1 2.2/s
Hit:Insert 1.16:1
__ Table Locks _________________________________________________________
Waited 1 0.0/s %Total: 0.00
Immediate 56.43k 4.5/s
__ Tables ______________________________________________________________
Open 271 of %Cache: 27100.
Opened 761 0.1/s
__ Connections _________________________________________________________
Max used 6 of 200 %Max: 3.00
Total 4.77k 0.4/s
__ Created Temp ________________________________________________________
Disk table 884 0.1/s
Table 1.41k 0.1/s
File 6 0.0/s
__ Threads _____________________________________________________________
Running 1 of 1
Cached 5 of 64 %Hit: 99.87
Created 6 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 0 0/s
Connects 6 0.0/s
__ Bytes _______________________________________________________________
Sent 278.30M 22.3k/s
Received 18.90M 1.5k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 27.41M of 127.98M %Used: 21.41
Read ratio 0.000
Pages
Free 6.44k %Total: 78.59
Data 1.73k 21.16 %Drty: 3.98
Misc 21 0.26
Latched 0.00
Reads 4.36M 350.3/s
From file 1.46k 0.1/s 0.03
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 12.09k 1.0/s
Flushes 1.36k 0.1/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 1.78k 0.1/s
Writes 1.92k 0.2/s
fsync 666 0.1/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 23 0.0/s
Read 1.71k 0.1/s
Written 1.36k 0.1/s
Rows
Deleted 605 0.0/s
Inserted 166 0.0/s
Read 161.87k 13.0/s
Updated 134 0.0/s
|
