Performance Insights option is not available while modifying a database with Aurora Mysql 2.06 engine

Question

Hello,
On one of my RDS clusters, i got the recommendation to turn on performance insights.
When I tried to modify the database with Aurora Mysql 2.06 engine with instance type db.r4.xx , I am not getting the option to enable the insights.
Do I have to upgrade it to a higher minor version (2.07 or 2.09) to get that option visible?

Thanks

Accepted Answer

Hi,

Thank you for asking your question.

Aurora MySQL2.06 version is already deprecated [1]. After upgrade to 2.07.9(latest LTS version as of writing) or 2.11.3/2.12.0, you can see this option in the console.

[1] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraMySQLReleaseNotes/AuroraMySQL.Updates.20Updates.html

I hope this might help.

Answer

Hi,

[Performance Insights ](https://repost.aws/knowledge-center/aurora-mysql-performance-insights-errors) is compatible with Amazon Aurora MySQL-Compatible 2.04.2 and higher 2.x versions, except for Aurora DB clusters that allow for parallel queries, which requieres 2.09.0. In that your case?

On the other hand and just to confirm, you [must turn on Performance Insights](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_PerfInsights.Enabling.html) on for each instance in the cluster, not at the cluster level. Is what you're doing?

Answer

Hi, based on those 2 articles, it should work. You can't see this option in a console?

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_PerfInsights.Overview.Engines.html

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.Aurora_Fea_Regions_DB-eng.Feature.PerfInsights.html#Concepts.Aurora_Fea_Regions_DB-eng.Feature.PerfInsights.amy

In a console the earliest version is 2.07.9 and it has Performance insight option.

Maybe you need to update to 2.07.9.

Performance Insights option is not available while modifying a database with Aurora Mysql 2.06 engine

Contenido relevante