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 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南