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?

질문됨 일 년 전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
답변함 일 년 전
profile picture
전문가
검토됨 일 년 전
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.

답변함 일 년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인