我正在使用极光实例。我已更新我的参数组以打开性能架构并重新启动实例。但是 events_statements_history 已关闭。
我错过了什么或如何实现？
select * from setup_consumers where name like 'events%statement%';
+--------------------------------+---------+
| NAME | ENABLED |
+--------------------------------+---------+
| events_statements_current | YES |
| events_statements_history | NO |
| events_statements_history_long | NO |
+--------------------------------+---------+
最佳答案
目前无法在 AWS 控制台中的任何位置进行设置。您可以执行此操作以将其打开:
use performance_schema; update setup_consumers set enabled='yes' WHERE name = 'events_statements_history';"
但是，每次重新启动 Aurora 实例时都必须重新执行此操作。
MySQL > show global variables like 'performance_schema';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| performance_schema | ON |
+--------------------+-------+
1 row in set (0.00 sec)
use performance_schema;
MySQL [performance_schema]> select * from setup_consumers WHERE name = 'events_statements_history';
+---------------------------+---------+
| NAME | ENABLED |
+---------------------------+---------+
| events_statements_history | NO |
+---------------------------+---------+
1 row in set (0.01 sec)
MySQL [performance_schema]> update setup_consumers set enabled='yes'
WHERE name = 'events_statements_history';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MySQL [performance_schema]> select * from setup_consumers WHERE name =
'events_statements_history';
+---------------------------+---------+
| NAME | ENABLED |
+---------------------------+---------+
| events_statements_history | YES |
+---------------------------+---------+
1 row in set (0.00 sec)
关于mysql - AWS Aurora 性能架构，如何启用 events_statements_history，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/47163201/