My amazon mysql large RDS instance's CPU utilization is going very high (about 70%) without any genuine reason. How to find which query or process is harming my instance?
The standard method is to examine SHOW PROCESSLIST or SHOW ENGINE InnoDB STATUS to see what's going on.
You are using InnoDB, right?
0
votes
It could also be due to the autoback feature RDS provides. I think AWS RDS does an automatic back up around midnight everyday, you must factor this into your calculations
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkRead more
