Unable to update max_connections for RDS instance
I would like to increase the max_connections setting in my rds aurora mysql instance to avoid the "too many connections" error.
I created a new parameter group with max_connections=200, and assigned it to my instance:
I set the "Modify Immediately" setting when I assigned the parameter group to the instance, then I rebooted my RDS instance.
When I sign into my database and run "show variables like 'max_connections';" I'm still getting the previous value of 90.
What did I do wrong? Thank you!
- Newest
- Most votes
- Most comments
Hello.
I changed the settings in my AWS account according to the steps in the document below, and confirmed that the settings were reflected.
Therefore, please check again to make sure that you have not set the parameter group to the wrong instance and that the parameter group has been reflected.
Also, try changing and checking the settings of the cluster parameter group as well as the instance parameter group.
https://repost.aws/knowledge-center/aurora-postgresql-max-connections
Hello,
Can you check the RDS instance , under Configuration tab , for "DB instance parameter group" whether it is showing "In-Sync" in green or any other status ?
Hello,
Please Follow this document step by step to resolve your issue:
https://repost.aws/knowledge-center/rds-mysql-too-many-connections
https://repost.aws/knowledge-center/aurora-postgresql-max-connections
The parameter group change won't take effect until the instance is rebooted and the new parameter group is applied, so try rebooting the instance again and then check the "max_connections" value.
Hi,
The procedure to update max_connections for mysql is fully detailled here: https://repost.aws/knowledge-center/rds-mysql-max-connections
Best,
Didier
Relevant content
- asked 2 years ago
AWS OFFICIALUpdated 4 years ago- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
