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 Antwort
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
beantwortet vor 7 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen