2 Answers
- Newest
- Most votes
- Most comments
0
It sounds like you are short on memory. You can resize the innodb-buffer-pool-size to something lower than the default.
When you switched to innodb, you started using the buffer pool more than before, the swapping is evidence that you ran out of memory.
-Phil
0
Thanks Phil!
These 2 days I focus on trying lower down the default innodb_buffer_pool_size to 2.5GB and 2GB. The server seems more stable than before. Default was 3GB, but when the issue happening I already lower down to 2.75GB. During my research online, I always saw that should not make changes on the RDS default parameter group. It seems in my case it need adjustment to lower down the memory usage to make server stable.
Thanks again for pointing out and confirming the direction!
answered 5 years ago
Relevant content
- asked 3 months ago
- asked 2 months ago
- Accepted Answerasked 2 years ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago