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개 답변
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
답변함 7년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인