RDS Performance Insights not showing SQL statistics

1

Hi there, looking for help for a RDS performance insight issue:

We are using a t4g.large RDS instance with MySQL 8.0.32 and multiAZ. As the screenshot below, our RDS performance insight is not showing SQL statistics properly: Enter image description here

This began several weeks ago, some heavy loads from the users have overwhelmed our RDS, so we upgraded the storage type from gp2 to gp3, rebooted with a failover and also temporarily upgraded our RDS instance from t4g.large to t4g.xlarge. Then after the burst of load was over, we downgraded the instance back to t4g.large, and upgraded the MySQL engine version from 8.0.29 to 8.0.32 at the same time.

Ever since then, our RDS performance insight has stopped showing SQL statistics. We have tried several methods like turn off performance insight and turn on again, reboot RDS instance, set performance schema to automatic management, etc., but the issue is remain unsolved. When I look into the data in MySQL table, performance_schema.events_statements_summary_by_digest, it seems the data is there , just not being displayed to the performance insight dashboard. I wonder if anyone has ever encountered a similar issue or know the way to resolve it.

Any help is greatly appreciated. Thanks in advance!

1 Answer
1
Accepted Answer

if your instance enabled the performance_schema parameter, the performance insight metric not shown some information. So, AWS Public doc recommend The performance_schema parameter is set to 0. The Source is set to system, which is the default. after that, enabled the performance insight feature. Note 1* Performance Schema : To turn this feature on or off, you must reboot the DB instance. Note 2* When Performance Insights turns on the Performance Schema, it doesn't change the parameter group values. However, the values are changed on the DB instances that are running. The only way to see the changed values is to run the SHOW GLOBAL VARIABLES command.

[+] Turning on the Performance Schema for Performance Insights on Amazon RDS for MariaDB or MySQL - Performance Insights and the Performance Schema - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.EnableMySQL.html#USER_PerfInsights.effect-of-pfs [+] Turning on the Performance Schema for Performance Insights on Amazon RDS for MariaDB or MySQL - Automatic management of the Performance Schema by Performance Insights - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.EnableMySQL.html#USER_PerfInsights.EnableMySQL.options

profile pictureAWS
SUPPORT ENGINEER
answered a year 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