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>
Topics
asked a month ago27 views
1 Answers
0
Hello, could you please verify which parameter was set for timeouts. Aurora does not have a max_timeout parameter.
answered a month ago
Relevant questions
Aurora MySQL parameter group set `block_encryption_mode`
asked 3 months agoAWS RDS Aurora MySql Serverless: ft_min_word_len is not being recognized
asked 3 months agoHow do I upgrade MySQL from 5.6 -> 5.7 with custom parameter groups
Accepted Answerasked 5 months agoRDS Aurora parameter group max_timeout custom setting not reflecting on the DB even after a reboot
asked a month agoRDS Postgresql migrate to Aurora Postgresql. Not showing "Aurora read replica" & "Migrate snapshot" options.
Accepted Answerasked 6 months agoAurora MYSQL Max_Connections Number
Accepted Answerasked a month agoChanges to server_collation on aurora mysql8 instance is not applied
Accepted Answerasked 6 months agoCDK: custom endpoints for Aurora cluster?
asked 6 months agoevent_scheduler is OFF in Aurora MySQL Serverless DB despite being set in the parameter group
Accepted Answerasked 5 days agoAWS RDS Aurora Ability to Change log_line_prefix or add %a To Default To Log Application
asked 3 months ago
Hi, @Motley.
MySQL has multiple timeout related parameters, which parameter did you set to 30 seconds? innodb_lock_wait_timeout?