My server crashed 3 times in the last week from out of memory.
- Server is ubuntu 14.04 with 8Gb ram.
- MySql server 5.5.50
Below is a graph from munin:
I didn't have the historical ram consumption from munin. Luckily we track it and store it in a database:
Consumption increased steadily over the last few weeks
My main assumption is that mysql is the cause. I am not sure that current usage of our application can explain this increase.
- How can I know for sure that mysql is the highest consumer of (committed) memory?
- I am currently checking mysqltuner and the slow log. Is there a way to check which queries consume the most ram?
- Anything else that you think I should check?