Performance Insights Shows Nothing After Changing Instance Type from db.r5.8xlarge to db.r5.16xlarge for Aurora MySQL

0

We were originally using a db.r5.8xlarge as our write instance, and Performance Insights was displaying the DB load queries properly. However, after updating to a db.r5.16xlarge more than a week ago, nothing has been displayed in the DB load on Performance Insights. Given that we often experience heavy load situations with CPU usage over 80%, it seems unlikely that the absence of recorded data is due to a lack of DB load. The performance_schema, which many guides suggest checking, is currently set to System default, so it doesn't seem to be the issue either.

The measures we have taken include:

  1. Resetting the performance_schema and then rebooting the DB instance.
  2. Turning off Performance Insights and rebooting, and waiting for 2 hours before turning it back on and rebooting. (After this, one query was saved in the DB load, but then it stopped saving again.) An interesting fact is that the read replicas added within the same Aurora cluster are also not accumulating any DB load in Performance Insights despite being enabled.

Is there anything we need to check more?

1 Answer
0

Given the high CPU usage, please note Performance Insights data is captured by an agent on the host. This agent consumes limited CPU and memory on the DB host. However, when the DB load is high, the agent limits the performance impact by collecting data less frequently. [https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Enabling.html]

Please also note, when Performance Insights turns on the Performance Schema, it doesn't change the performance_schema parameter values. However, the values are changed on the DB instances that are running. Please review if the values are changed using the SHOW GLOBAL VARIABLES command.

Lastly, if you have not looked at this article yet, please review https://repost.aws/knowledge-center/rds-mysql-performance-insights

AWS
answered 18 days ago
profile picture
EXPERT
reviewed 16 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions