MySQL RDS 'max_connections_per_hour' error, what are my options?

Question

I'm getting the following error for a DB I have. (db.t2.micro)

```
“1226 (42000): User ‘?????????’ has exceeded the ‘max_connections_per_hour’ resource (current value: 85)”
```

What can I do to increase max connections per hour?

I did see possible solutions on [here](https://dev.mysql.com/doc/refman/8.0/en/user-resources.html) but they don't seem to work in RDS.

Most of the solutions that I read about include upgrading the instance, which I am willing to do but for my current application it would be overkill. Most of my open and close connections are simple api request.

85 connections in an hour doesn't seem like much, there has to be another solution.

Answer

One option to increase your max_connections is to add db connection pooling using RDS Proxy. 
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html

The database connections will remain open meanwhile the application (I assume that is serverless) will be connecting to RDS Proxy without hitting the max_connection limit.

Answer

In RDS max_connections is dependent on instance size. For MySQL the calculation is

`{DBInstanceClassMemory/12582880}`

A t2.micro has 1GB of memory.

If you make the division it comes to 85.3.

So choosing a larger instance will give you more connections.

Doc: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Limits.html#RDS_Limits.MaxConnections

MySQL RDS 'max_connections_per_hour' error, what are my options?

相關內容