RDS increase max connections for MySQL 5.6.10

0

I have a RDS medium.
The command: select @@max_connections shows 90
The free memory:
803772 free
rds endpoint: gym.cluster-coh9kf7kotgs.us-east-1.rds.amazonaws.com

According to other responses to similar questions, the default for this server should be around:
296

I need to increase max connections, but the configuration is kinda clumsy.
How should i proceed to increase max conn?
Can you help me to configure?
Thanks

1 Answer
0

You can increase max_connections by specifying a new value in the DB Parameter Group. Instructions are at http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html, and for simplicity ignore the CLI and API examples and just stick with the AWS Management Console.

Theses are discussion forums, and 1-on-1 technical support here is intermittent at best. When I look at the AWS Support comparison page at https://aws.amazon.com/premiumsupport/compare-plans/ it shows that Basic Support does NOT include Technical Support. A suggestion I would make is that if you need individualized technical support then you should sign up for Developer Support. It starts at $29/month, which is less than I've had other vendors charge for per-incident support. So you could sign up for Developer Support, open up a case, then (if you want to) cancel support before the start of the following month to avoid additional charges. https://aws.amazon.com/premiumsupport/developer-support/

HalTemp
answered 7 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions