Skip to content

I get `ER_CON_COUNT_ERROR: Too many connections ` errors when using Aurora

0

I recently moved from RDS to Aurora and now I get ER_CON_COUNT_ERROR: Too many connections errors on my webpage. I have updated the instance sizes from small to large but that has not helped.

asked a year ago305 views
1 Answer
0

Hello.

Have you changed the "max_connections" value set in the RDS Aurora parameter group?
By default, if you increase the instance size, the maximum number of connections will also increase.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Performance.html

Also, when connecting to RDS from an application, is the connection properly disconnected at the end of processing?
In other words, I think it is necessary to check whether there are any unnecessary connections remaining.

EXPERT
answered a year ago
AWS
EXPERT
reviewed a year ago
  • I am not sure I am disconnecting properly I have upped the max_connections to 1000

  • If this happens, I think it is possible that the application is not properly disconnecting from the database.

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.