- Newest
- Most votes
- Most comments
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
Relevant content
- asked 4 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago