RDS Aurora parameter group max_timeout custom setting not reflecting on the DB even after a reboot

0

I'm trying to change an Aurora instance's max_timeout setting to 30 secs via a custom parameter group. I find the parameter and edit it and save. I see the DB instance shows modifying. When it's done if I connect to the DB instance and run the below the max_timeout value has not changed. I have even tried a reboot on the DB instance, again no luck. Why is this not working? Must I pay for support to create a case which is clearly an issue with AWS.

mysql> show variables like "%wait_timeout%";
+----------------------------------+----------+
| Variable_name                    | Value    |
+----------------------------------+----------+
| aurora_globaldb_rpo_wait_timeout | 60       |
| innodb_lock_wait_timeout         | 50       |
| lock_wait_timeout                | 31536000 |
| wait_timeout                     | 28800    |
+----------------------------------+----------+
4 rows in set (0.00 sec)

mysql>
  • Hi, @Motley.

    MySQL has multiple timeout related parameters, which parameter did you set to 30 seconds? innodb_lock_wait_timeout?

Motley
已提问 2 年前885 查看次数
2 回答
0

Hello, could you please verify which parameter was set for timeouts. Aurora does not have a max_timeout parameter.

AWS
已回答 2 年前
0

Can you please suggest which parameters you tried to modify , there are certain parameters which can be set on Cluster parameter group and some can only be set on the Instance level parameter group. Provided if the timeout parameter you configured is on cluster level you need to bounce the entire cluster.

Please provide in more details of the parameters you tried and the value you set?

AWS
SSaxena
已回答 10 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则