|
Mysql status
MySQL 10.1.47-MariaDB-0 uptime 2 16:58:53 Mon Jan 25 10:30:01 2021
__ Key _________________________________________________________________
Buffer used 4.73M of 128.00M %Used: 3.69
Current 25.74M %Usage: 20.11
Write ratio 0.588
Read ratio 0.022
__ Questions ___________________________________________________________
Total 1.94M 8.3/s
DMS 1.44M 6.1/s %Total: 74.10
-Unknown 763.91k 3.3/s 39.44
QC Hits 716.59k 3.1/s 37.00
Com_ 450.31k 1.9/s 23.25
COM_QUIT 98.55k 0.4/s 5.09
Slow 37 0.0/s 0.00 %DMS: 0.00
DMS 1.44M 6.1/s 74.10
SELECT 1.21M 5.2/s 62.38 84.18
UPDATE 145.93k 0.6/s 7.53 10.17
INSERT 55.40k 0.2/s 2.86 3.86
DELETE 25.26k 0.1/s 1.30 1.76
REPLACE 383 0.0/s 0.02 0.03
Com_ 450.31k 1.9/s 23.25
set_option 206.78k 0.9/s 10.68
change_db 130.36k 0.6/s 6.73
admin_comma 46.60k 0.2/s 2.41
__ SELECT and Sort _____________________________________________________
Scan 183.98k 0.8/s %SELECT: 15.23
Range 58.74k 0.3/s 4.86
Full join 701 0.0/s 0.06
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 30.85k 0.1/s
Sort range 6.63k 0.0/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 32.60M of 64.00M %Used: 50.94
Block Fragmnt 3.23%
Hits 716.59k 3.1/s
Inserts 355.85k 1.5/s
Insrt:Prune 355.85k:1 1.5/s
Hit:Insert 2.01:1
__ Table Locks _________________________________________________________
Waited 263 0.0/s %Total: 0.03
Immediate 958.09k 4.1/s
__ Tables ______________________________________________________________
Open 194 of %Cache: 19400.
Opened 64.39k 0.3/s
__ Connections _________________________________________________________
Max used 8 of 200 %Max: 4.00
Total 98.55k 0.4/s
__ Created Temp ________________________________________________________
Disk table 80.47k 0.3/s
Table 125.21k 0.5/s
File 6 0.0/s
__ Threads _____________________________________________________________
Running 1 of 2
Cached 6 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.24G 73.7k/s
Received 397.62M 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.14
Misc 41 0.50
Latched 0.00
Reads 83.15M 355.5/s
From file 4.56k 0.0/s 0.01
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 56.24k 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.42k 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 969 0.0/s
Read 3.50M 15.0/s
Updated 2.30k 0.0/s
|