|
Mysql status
MySQL 10.3.39-MariaDB-0 uptime 0 14:19:57 Sat Dec 14 16:20:01 2024
__ Key _________________________________________________________________
Buffer used 4.95M of 32.00M %Used: 15.46
Current 7.60M %Usage: 23.76
Write ratio 1.000
Read ratio 0.001
__ Questions ___________________________________________________________
Total 824.44k 16.0/s
DMS 698.70k 13.5/s %Total: 84.75
Com_ 111.74k 2.2/s 13.55
-Unknown 91.00k 1.8/s 11.04
QC Hits 80.35k 1.6/s 9.75
COM_QUIT 24.65k 0.5/s 2.99
Slow 7 0.0/s 0.00 %DMS: 0.00
DMS 698.70k 13.5/s 84.75
INSERT 545.74k 10.6/s 66.19 78.11
SELECT 145.97k 2.8/s 17.71 20.89
UPDATE 6.97k 0.1/s 0.85 1.00
DELETE 18 0.0/s 0.00 0.00
REPLACE 0 0/s 0.00 0.00
Com_ 111.74k 2.2/s 13.55
set_option 53.57k 1.0/s 6.50
change_db 25.94k 0.5/s 3.15
show_create 9.56k 0.2/s 1.16
__ SELECT and Sort _____________________________________________________
Scan 40.23k 0.8/s %SELECT: 27.56
Range 126 0.0/s 0.09
Full join 14 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 6.97k 0.1/s
Sort range 2.76k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 986.22k of 64.00M %Used: 1.50
Block Fragmnt 3.36%
Hits 80.35k 1.6/s
Inserts 14.85k 0.3/s
Insrt:Prune 14.85k:1 0.3/s
Hit:Insert 5.41:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 618.17k 12.0/s
__ Tables ______________________________________________________________
Open 96 of %Cache: 9600.0
Opened 24.28k 0.5/s
__ Connections _________________________________________________________
Max used 36 of 100 %Max: 36.00
Total 24.65k 0.5/s
__ Created Temp ________________________________________________________
Disk table 24.57k 0.5/s
Table 38.96k 0.8/s
File 5 0.0/s
__ Threads _____________________________________________________________
Running 6 of 4
Cached 7 of 64 %Hit: 99.84
Created 39 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 3 0.0/s
Connects 62 0.0/s
__ Bytes _______________________________________________________________
Sent 5.93G 115.0k/s
Received 939.24M 18.2k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 108.81M of 128.00M %Used: 85.01
Read ratio 0.005
Pages
Free 1.23k %Total: 14.99
Data 6.46k 78.85 %Drty: 0.00
Misc 505 6.16
Latched 0.00
Reads 1.11M 21.5/s
From file 5.41k 0.1/s 0.49
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 29.27k 0.6/s
Flushes 11.09k 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.40k 0.1/s
Writes 34.21k 0.7/s
fsync 30.03k 0.6/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 132 0.0/s
Read 6.33k 0.1/s
Written 11.09k 0.2/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 1.57M 30.4/s
Updated 3.95k 0.1/s
|
