|
Mysql status
MySQL 5.5.60-0+deb7u1-l uptime 20 15:16:0 Sun May 19 10:50:01 2019
__ Key _________________________________________________________________
Buffer used 26.16M of 128.00M %Used: 20.43
Current 31.59M %Usage: 24.68
Write ratio 0.525
Read ratio 0.005
__ Questions ___________________________________________________________
Total 21.63M 12.1/s
QC Hits 9.06M 5.1/s %Total: 41.86
DMS 7.34M 4.1/s 33.92
Com_ 4.83M 2.7/s 22.31
COM_QUIT 794.43k 0.4/s 3.67
-Unknown 381.97k 0.2/s 1.77
Slow 1.21k 0.0/s 0.01 %DMS: 0.02
DMS 7.34M 4.1/s 33.92
SELECT 5.36M 3.0/s 24.78 73.05
UPDATE 1.14M 0.6/s 5.29 15.60
INSERT 445.94k 0.3/s 2.06 6.08
DELETE 242.46k 0.1/s 1.12 3.30
REPLACE 144.14k 0.1/s 0.67 1.96
Com_ 4.83M 2.7/s 22.31
set_option 2.24M 1.3/s 10.35
change_db 1.27M 0.7/s 5.87
admin_comma 380.26k 0.2/s 1.76
__ SELECT and Sort _____________________________________________________
Scan 1.52M 0.9/s %SELECT: 28.34
Range 1.14M 0.6/s 21.32
Full join 7.65k 0.0/s 0.14
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 590.44k 0.3/s
Sort range 419.58k 0.2/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 50.98M of 64.00M %Used: 79.66
Block Fragmnt 17.66%
Hits 9.06M 5.1/s
Inserts 4.36M 2.4/s
Insrt:Prune 2.30:1 1.4/s
Hit:Insert 2.08:1
__ Table Locks _________________________________________________________
Waited 2.31k 0.0/s %Total: 0.03
Immediate 7.41M 4.2/s
__ Tables ______________________________________________________________
Open 1.02k of %Cache: 102300
Opened 419.76k 0.2/s
__ Connections _________________________________________________________
Max used 48 of 200 %Max: 24.00
Total 794.70k 0.4/s
__ Created Temp ________________________________________________________
Disk table 476.35k 0.3/s
Table 964.98k 0.5/s
File 10 0.0/s
__ Threads _____________________________________________________________
Running 1 of 4
Cached 44 of 64 %Hit: 99.99
Created 48 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 530 0.0/s
Connects 180 0.0/s
__ Bytes _______________________________________________________________
Sent 144.00G 80.8k/s
Received 3.34G 1.9k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 127.95M of 128.00M %Used: 99.96
Read ratio 0.000
Pages
Free 3 %Total: 0.04
Data 8.11k 98.99 %Drty: 0.00
Misc 80 0.98
Latched 0.00
Reads 54.02M 30.3/s
From file 9.97k 0.0/s 0.02
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 2.87M 1.6/s
Flushes 641.48k 0.4/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 6 0.0/s
Current 0
Time acquiring
Total 63 ms
Average 10 ms
Max 63 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 10.16k 0.0/s
Writes 910.04k 0.5/s
fsync 293.86k 0.2/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 10.11k 0.0/s
Read 10.15k 0.0/s
Written 641.48k 0.4/s
Rows
Deleted 107.70k 0.1/s
Inserted 131.58k 0.1/s
Read 36.66M 20.6/s
Updated 98.33k 0.1/s
|
