amazon-web-services - AWS RDS Performance Insights 未显示 SQL 查询

Question

我在 AWS RDS 中的现有 SQL Server 数据库 (MySql 5.6.46) 上启用了 Performance Insights。
但是，无论我从顶部列表中选择什么持续时间，它仍然显示 0 个 session 和“所选时间范围内没有事件 session ”。

是否需要满足某些条件才能将我的查询记录在 Performance Insights 中？标准是什么？我该如何解决这个问题？

Answer 1

我创建了 AWS Support 案例，AWS 工程师向我解释了:

Unfortunately, this is a known issue from our end where Performance Insights does not get enabled when it is issued in the same API call as engine version upgrade as RDS follows a priority in executing multiple requests that have been submitted as part of the same API call - for example in this case, request to enable Performance Insights and request to upgrade the instance to 11.1 version. Performance Insights call is evaluated first followed by the engine upgrade. This means that when Performance Insights request was being considered, the instance was still on the previous incompatible version, hence the request did not go through successfully.

The workaround to resolve this issue is to disable Performance insights, wait a few minutes and then re-enable Performance Insights.

Enabling/disabling Performance Insights does not cause an outage/downtime. The Performance Insights agent is designed to stay out of your database workloads' way. When Performance Insights detects heavy load or depleted resources, it backs off, still collecting data, but only when it is safe to do so.