AWS RDS connection count

Question

I am using AWS RDS with MySQL for a project and have a "large" instance. The documentation is clear on what this means as far as compute resources and RAM goes, but I can't find anything that documents how many open database connections that I can have. The app that I am using is PHP and it utilizes PDO with persistent connections. This means that the number of open connections could reach the maximum number of PHP child processes running at any given point. How do I ensure that my RDS instance has a max connections setting high enough to be comfortable with this?

score 16 · Accepted Answer · answered Aug 06 '12 at 18:18

According to this 2011 blog post, the max connections on RDS instances come out this way:

t1.micro: 34 connections ($0.035)
m1.small: 150 connections ($0.115)
m1.large: 640 connections ($0.455)
m1.xlarge: 1263 connections ($0.920)
m2.xlarge: 1441 connections ($0.655)
m2.2xlarge: 2900 connections ($1.315)
m2.4xlarge: 5816 connections ($2.630)

No AWS docs I can find demonstrate this information is current, but other sources suggest if it isn't, it's very close. You can find your instances max connections with:

show variables like '%conn%';

from the mysql terminal, or via an SDK.

thanks I'd scoured the docs with no luck. Great find! – wmarbut Aug 06 '12 at 18:52 — wmarbut, Aug 06 '12 at 18:52

Marat · Answer 2 · 2012-08-29T02:10:29.027

3

You can always check actual value in AWS console. Open RDS -> DB Parameter Groups, probably you have only one parameter group there, e.g. default.mysql5.5. Then, check max-connections parameter. In my case it is {DBInstanceClassMemory/12582880}, ie ~50 connections for micro instance, ~150 for small etc.

edited Aug 29 '12 at 02:10

answered Aug 28 '12 at 23:48

Marat

131
3

score 2 · Answer 3 · answered Feb 24 '15 at 10:21

2

From RDS Console > Parameter Groups > Edit Parameters,

You can change the value of the max_connections parameter to a custom value.

answered Feb 24 '15 at 10:21

eaykin

121
2

score 0 · Answer 4 · answered Jul 01 '22 at 12:59

0

We can change the limit but the connection is not extending for RDS instance type t3.medium. Max 100 connections are there. After that web server goes down. Can anyone suggest to increase the connection limition?

answered Jul 01 '22 at 12:59

Prabesh

1

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Jul 02 '22 at 17:17

AWS RDS connection count

4 Answers4