|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 23 22:50:50 Wed May 8 17:00:01 2024
__ Key _________________________________________________________________
Buffer used 5.82M of 32.00M %Used: 18.19
Current 5.90M %Usage: 18.45
Write ratio 1.000
Read ratio 0.000
__ Questions ___________________________________________________________
Total 42.35M 20.5/s
DMS 38.80M 18.7/s %Total: 91.62
-Unknown 3.93M 1.9/s 9.28
QC Hits 3.35M 1.6/s 7.90
Com_ 3.34M 1.6/s 7.90
COM_QUIT 787.76k 0.4/s 1.86
Slow 90 0.0/s 0.00 %DMS: 0.00
DMS 38.80M 18.7/s 91.62
INSERT 33.49M 16.2/s 79.07 86.31
SELECT 5.04M 2.4/s 11.90 12.99
UPDATE 270.37k 0.1/s 0.64 0.70
DELETE 560 0.0/s 0.00 0.00
REPLACE 43 0.0/s 0.00 0.00
Com_ 3.34M 1.6/s 7.90
set_option 1.35M 0.7/s 3.18
change_db 972.07k 0.5/s 2.30
show_create 236.34k 0.1/s 0.56
__ SELECT and Sort _____________________________________________________
Scan 1.05M 0.5/s %SELECT: 20.93
Range 3.84k 0.0/s 0.08
Full join 242 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 180.08k 0.1/s
Sort range 232.54k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 714.41k of 64.00M %Used: 1.09
Block Fragmnt 4.94%
Hits 3.35M 1.6/s
Inserts 655.64k 0.3/s
Insrt:Prune 655.64k:1 0.3/s
Hit:Insert 5.11:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 35.36M 17.1/s
__ Tables ______________________________________________________________
Open 110 of %Cache: 11000.
Opened 407.45k 0.2/s
__ Connections _________________________________________________________
Max used 64 of 100 %Max: 64.00
Total 787.83k 0.4/s
__ Created Temp ________________________________________________________
Disk table 592.07k 0.3/s
Table 940.32k 0.5/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 7 of 5
Cached 4 of 64 %Hit: 99.98
Created 122 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 116 0.0/s
Connects 50.13k 0.0/s
__ Bytes _______________________________________________________________
Sent 183.74G 88.8k/s
Received 48.39G 23.4k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 112.00M of 128.00M %Used: 87.50
Read ratio 0.000
Pages
Free 1.02k %Total: 12.50
Data 6.64k 81.12 %Drty: 0.00
Misc 523 6.38
Latched 0.00
Reads 50.93M 24.6/s
From file 5.86k 0.0/s 0.01
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 1.19M 0.6/s
Flushes 441.66k 0.2/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 6.90k 0.0/s
Writes 1.30M 0.6/s
fsync 1.14M 0.5/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 133 0.0/s
Read 6.83k 0.0/s
Written 441.66k 0.2/s
Rows
Deleted 531 0.0/s
Inserted 38 0.0/s
Read 64.59M 31.2/s
Updated 158.22k 0.1/s
|
