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

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ