InnoDB Buffer Pool 이 100% 여서 128 > 256 으로 변경 했으나 역시 100%
시스템 사양은 4 core, 8gb ram , KT ucloud 서버 입니다. ㅠ
top 에서 mysql CPU가 500% 왔다 갔다 하네요..
슬로우 쿼리로 로그 보고 있는데 3초 걸리는 쿼리가 있습니다.
쿼리 개선하는거 말고 봐야 할께 또 있을까요?
__ Key _________________________________________________________________
Buffer used 0 of 128.00M %Used: 0.00
Current 23.34M %Usage: 18.24
Write hit 0.00%
Read hit 0.00%
__ Questions ___________________________________________________________
Total 80.89k 496.2/s
DMS 77.59k 476.0/s %Total: 95.93
Com_ 2.59k 15.9/s 3.21
COM_QUIT 710 4.4/s 0.88
-Unknown 9 0.1/s 0.01
Slow 3 s 2 0.0/s 0.00 %DMS: 0.00 Log: ON
DMS 77.59k 476.0/s 95.93
SELECT 72.42k 444.3/s 89.53 93.33
UPDATE 2.68k 16.4/s 3.31 3.45
INSERT 1.48k 9.1/s 1.83 1.91
DELETE 1.01k 6.2/s 1.25 1.31
REPLACE 0 0/s 0.00 0.00
Com_ 2.59k 15.9/s 3.21
set_option 1.42k 8.7/s 1.75
change_db 708 4.3/s 0.88
show_fields 463 2.8/s 0.57
__ SELECT and Sort _____________________________________________________
Scan 1.67k 10.2/s %SELECT: 2.30
Range 10.71k 65.7/s 14.80
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 8.82k 54.1/s
Sort range 2.98k 18.3/s
Sort mrg pass 80 0.5/s
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 91.11k 559.0/s
__ Tables ______________________________________________________________
Open 110 of 400 %Cache: 27.50
Opened 84 0.5/s
__ Connections _________________________________________________________
Max used 28 of 151 %Max: 18.54
Total 712 4.4/s
__ Created Temp ________________________________________________________
Disk table 4.14k 25.4/s
Table 9.38k 57.6/s Size: 16.0M
File 121 0.7/s
__ Threads _____________________________________________________________
Running 2 of 9
Cached 0 of 0 %Hit: 0.14
Created 711 4.4/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 0 0/s
Connects 1 0.0/s
__ Bytes _______________________________________________________________
Sent 401.21M 2.5M/s
Received 11.45M 70.2k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 255.98M of 255.98M %Used: 100.00
Read hit 96.90%
Pages
Free 0 %Total: 0.00
Data 16.05k 97.97 %Drty: 0.37
Misc 333 2.03
Latched 0.00
Reads 175.72M 1.1M/s
From file 5.45M 33.5k/s 3.10
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 40.06k 245.8/s
Flushes 11.50k 70.6/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 10 0.1/s
Current 0
Time acquiring
Total 2 ms
Average 0 ms
Max 0 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 5.56M 34.1k/s
Writes 16.96k 104.0/s
fsync 5.47k 33.6/s
Pending
Reads 0
Writes 0
fsync 0
Pages
Created 105 0.6/s
Read 5.56M 34.1k/s
Written 11.50k 70.6/s
Rows
Deleted 1.01k 6.2/s
Inserted 1.48k 9.1/s
Read 82.27M 504.7k/s
Updated 4.83k 29.6/s
잡담 | 1102명이 읽었어요. 18.226.165.247
