|
Mysql status
MySQL 5.5.60-0+deb7u1-l uptime 41 10:5:50 Sun Apr 21 07:00:01 2019
__ Key _________________________________________________________________
Buffer used 22.21M of 128.00M %Used: 17.35
Current 30.39M %Usage: 23.75
Write ratio 0.551
Read ratio 0.012
__ Questions ___________________________________________________________
Total 48.32M 13.5/s
DMS 20.55M 5.7/s %Total: 42.53
QC Hits 17.37M 4.9/s 35.95
Com_ 9.73M 2.7/s 20.15
COM_QUIT 1.65M 0.5/s 3.42
-Unknown 990.85k 0.3/s 2.05
Slow 561 0.0/s 0.00 %DMS: 0.00
DMS 20.55M 5.7/s 42.53
SELECT 15.68M 4.4/s 32.45 76.29
UPDATE 2.79M 0.8/s 5.77 13.57
INSERT 1.02M 0.3/s 2.11 4.95
DELETE 792.37k 0.2/s 1.64 3.86
REPLACE 272.92k 0.1/s 0.56 1.33
Com_ 9.73M 2.7/s 20.15
set_option 4.32M 1.2/s 8.95
change_db 2.56M 0.7/s 5.30
admin_comma 988.52k 0.3/s 2.05
__ SELECT and Sort _____________________________________________________
Scan 3.20M 0.9/s %SELECT: 20.40
Range 2.07M 0.6/s 13.19
Full join 16.38k 0.0/s 0.10
Range check 0 0/s 0.00
Full rng join 5 0.0/s 0.00
Sort scan 1.18M 0.3/s
Sort range 1.38M 0.4/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 49.50M of 64.00M %Used: 77.35
Block Fragmnt 15.33%
Hits 17.37M 4.9/s
Inserts 13.74M 3.8/s
Insrt:Prune 3.47:1 2.7/s
Hit:Insert 1.26:1
__ Table Locks _________________________________________________________
Waited 21.77k 0.0/s %Total: 0.10
Immediate 22.14M 6.2/s
__ Tables ______________________________________________________________
Open 1.02k of %Cache: 102400
Opened 853.42k 0.2/s
__ Connections _________________________________________________________
Max used 38 of 200 %Max: 19.00
Total 1.66M 0.5/s
__ Created Temp ________________________________________________________
Disk table 946.68k 0.3/s
Table 1.83M 0.5/s
File 12 0.0/s
__ Threads _____________________________________________________________
Running 1 of 5
Cached 33 of 64 %Hit: 100
Created 38 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 394 0.0/s
Connects 313 0.0/s
__ Bytes _______________________________________________________________
Sent 313.10G 87.5k/s
Received 7.81G 2.2k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 127.97M of 127.98M %Used: 99.99
Read ratio 0.000
Pages
Free 1 %Total: 0.01
Data 8.10k 98.93 %Drty: 0.00
Misc 87 1.06
Latched 0.00
Reads 89.77M 25.1/s
From file 7.82k 0.0/s 0.01
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 3.66M 1.0/s
Flushes 785.37k 0.2/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 56 0.0/s
Current 0
Time acquiring
Total 28 ms
Average 0 ms
Max 16 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 8.27k 0.0/s
Writes 1.10M 0.3/s
fsync 349.11k 0.1/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 8.38k 0.0/s
Read 8.25k 0.0/s
Written 785.37k 0.2/s
Rows
Deleted 156.38k 0.0/s
Inserted 136.84k 0.0/s
Read 58.85M 16.4/s
Updated 127.91k 0.0/s
|
