High cpu usage on RDS MySQL instance for about 4 hours today

0

Hi,

We experienced high cpu usage on RDS MySQL instance today for about 4 hours. Our number of queries did not change drastically for the past year or so. Everything has been working fine until this morning. Then, queries started failing and we saw high cpu usage (close to 100%). Now, everything just went back to normal on its own. What happened?

已提问 1 年前329 查看次数
2 回答
0

There's a knowledge doc that addresses exactly this scenario https://repost.aws/knowledge-center/rds-sql-server-resolve-high-cpu-use You should definitely be looking at setting up gathering metrics with Performance Insights and CloudWatch (if you haven't already) in case this recurs.

Do you have backups setup for this database, and what time of day so they normally run? Could it be that it's normally an incremental (which you hardly notice) but maybe today it was a full?

Without knowing more about the RDS instance it's difficult to give more specific advice.

profile picture
专家
Steve_M
已回答 1 年前
profile picture
专家
已审核 1 年前
0

It is a db.t3.small, so I can't enable performance insights. The default automated backup is enabled to run at 06:15 UTC with 0.5hrs duration with 1 day retention. I am on PDT and when we experienced the high CPU usage was way past the 06:15UTC time.

已回答 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则