How can I troubleshoot common errors when enabling Performance Insights on my Amazon Aurora DB instance?

Last updated: 2020-12-21

I have an Amazon Aurora DB instance, and I would like to enable Performance Insights for my instance. How can I troubleshoot common errors I receive when I enable this feature?

Short description

Before you enable Performance Insights for Amazon Aurora, make sure that you are running a supported Aurora version and DB instance class. To use this feature, you must be running the following Amazon Aurora with MySQL compatibility versions:

  • 2.04.2 and higher 2.x versions (compatible with MySQL 5.7)
  • 1.17.3 and higher 1.x versions (compatible with MySQL 5.6)

Performance Insights are compatible with all versions of Amazon Aurora with PostgreSQL.

Note: For Aurora DB clusters enabled for parallel query, the minimum Aurora MySQL versions are 2.09.0 and 1.23.0. For more information, see Supported DB engines for Performance Insights.

To enable Performance Insights on your DB instance, see Modifying your DB instance using the Amazon RDS Console. Then, follow the troubleshooting steps in this article to resolve common errors that occur when enabling this feature.

Resolution

I can't see Performance Schema detailed wait events in my Performance Insights dashboard

If you have manually enabled the performance_schema parameter on your parameter group, reset the parameter. Then, modify your instance to disable and re-enable Performance Insights.

Performance Insights automatically manages the parameters in the following table. You can't configure this table using a custom parameter group. If you enable Performance Insights with performance_schema=1 on the cluster, this can lead to missing data points.

  • performance_schema: 1 (the source parameter is set to engine-default)
  • performance-schema-consumer-events-waits-current : ON
  • performance-schema-instrument: wait/% = ON
  • performance-schema-consumer-global-instrumentation: ON
  • performance-schema-consumer-thread-instrumentation = ON

I can't see my entire query in my Performance Insights dashboard

You might not be able to see query in full on the Performance Insights dashboard for Amazon Aurora. This might be because the feature currently has a limitation of 500 characters for Aurora PostgreSQL, and 1024 characters for Aurora MySQL. For more information, see Monitoring with the Performance Insights dashboard.

Note: If you enable or disable Performance Insights, this doesn't cause any downtime, reboot, or failover.