Performance Insights option is not available while modifying a database with Aurora Mysql 2.06 engine
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
- 最新
- 最多得票
- 最多評論
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?
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.
I hope this might help.
Thanks for your reply. Yes, that's the plan. I will upgrade it this weekend and let you know if it works.
It worked. Upgraded the minor version to 2.11.2 and Performance Insights are enabled now.
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
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.
The option is not available in the console when I am modifying the database/DB Cluster.
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.