|
Mysql status
MySQL 5.5.60-0+deb7u1-l uptime 15 1:45:50 Mon Mar 25 21:40:01 2019
__ Key _________________________________________________________________
Buffer used 22.21M of 128.00M %Used: 17.35
Current 36.91M %Usage: 28.84
Write ratio 0.573
Read ratio 0.011
__ Questions ___________________________________________________________
Total 16.03M 12.3/s
DMS 7.09M 5.4/s %Total: 44.20
QC Hits 5.25M 4.0/s 32.73
Com_ 3.59M 2.8/s 22.36
COM_QUIT 585.74k 0.4/s 3.65
-Unknown 473.70k 0.4/s 2.95
Slow 113 0.0/s 0.00 %DMS: 0.00
DMS 7.09M 5.4/s 44.20
SELECT 5.69M 4.4/s 35.50 80.31
UPDATE 757.20k 0.6/s 4.72 10.68
INSERT 305.25k 0.2/s 1.90 4.31
DELETE 222.49k 0.2/s 1.39 3.14
REPLACE 110.30k 0.1/s 0.69 1.56
Com_ 3.59M 2.8/s 22.36
set_option 1.52M 1.2/s 9.47
change_db 912.88k 0.7/s 5.69
admin_comma 473.09k 0.4/s 2.95
__ SELECT and Sort _____________________________________________________
Scan 1.10M 0.8/s %SELECT: 19.35
Range 744.79k 0.6/s 13.09
Full join 3.85k 0.0/s 0.07
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 445.61k 0.3/s
Sort range 574.36k 0.4/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 53.96M of 64.00M %Used: 84.31
Block Fragmnt 15.74%
Hits 5.25M 4.0/s
Inserts 4.96M 3.8/s
Insrt:Prune 3.81:1 2.8/s
Hit:Insert 1.06:1
__ Table Locks _________________________________________________________
Waited 446 0.0/s %Total: 0.01
Immediate 7.11M 5.5/s
__ Tables ______________________________________________________________
Open 1.02k of %Cache: 102400
Opened 316.02k 0.2/s
__ Connections _________________________________________________________
Max used 17 of 200 %Max: 8.50
Total 585.79k 0.4/s
__ Created Temp ________________________________________________________
Disk table 338.53k 0.3/s
Table 672.68k 0.5/s
File 9 0.0/s
__ Threads _____________________________________________________________
Running 2 of 6
Cached 11 of 64 %Hit: 100
Created 17 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 109 0.0/s
Connects 96 0.0/s
__ Bytes _______________________________________________________________
Sent 110.57G 84.9k/s
Received 2.39G 1.8k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 127.95M of 127.98M %Used: 99.98
Read ratio 0.000
Pages
Free 2 %Total: 0.02
Data 8.13k 99.22 %Drty: 0.00
Misc 62 0.76
Latched 0.00
Reads 32.12M 24.7/s
From file 7.51k 0.0/s 0.02
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 1.16M 0.9/s
Flushes 255.45k 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 7.96k 0.0/s
Writes 355.60k 0.3/s
fsync 112.25k 0.1/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 2.41k 0.0/s
Read 7.95k 0.0/s
Written 255.45k 0.2/s
Rows
Deleted 50.69k 0.0/s
Inserted 41.51k 0.0/s
Read 22.18M 17.0/s
Updated 41.54k 0.0/s
|
