By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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

0

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

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database ServiceAurora MySQLPerformance Insights
Language
English
profile picture
Kartikey Tripathi
asked a year ago382 views
3 Answers
2

Hi,

Performance Insights 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 on for each instance in the cluster, not at the cluster level. Is what you're doing?

profile picture
EXPERT
Mikel Del Tio
answered a year ago
  • Kartikey Tripathi
    a year ago

    Thanks for your reply. The aurora_parallel_query parameter is OFF in my case and I checked both instance and cluster properties, yet unable to find that option. I will be doing a minor upgrade to 2.11 to see if it works.

1
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.

AWS
YUTAKA_H
answered a year ago
profile picture
EXPERT
Sedat Salman
reviewed a year ago
  • Kartikey Tripathi
    a year ago

    Thanks for your reply. Yes, that's the plan. I will upgrade it this weekend and let you know if it works.

  • Kartikey Tripathi
    a year ago

    It worked. Upgraded the minor version to 2.11.2 and Performance Insights are enabled now.

1

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.

profile picture
myronix88
answered a year ago
  • Kartikey Tripathi
    a year ago

    The option is not available in the console when I am modifying the database/DB Cluster.

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

Relevant content