Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Amazon RDS (postgres) connection limit?

Tags:

amazon-rds

I've searched the web and browsed the RDS docs, yet I can't seem to find an open connection limit.

For what it's worth, I'm planning on using the new Postgres flavor of RDS, but I suppose an answer from the mySQL side of the house would be acceptable as well.

Thanks!

like image 318
cs44 Avatar asked Nov 20 '13 20:11

cs44


People also ask

What is Max Connection in RDS?

In this article we're going to explain MySQL RDS Max DB Connection Limits as per DB Instance Type. The current RDS MySQL max_connections setting is default by {DBInstanceClassMemory/12582880}, if you use t2. micro with 1GB RAM the max_connections could be (1024*1024*1024)/12582880 ~= 85.

What are the limitations of Amazon RDS?

MySQL file size limits in Amazon RDS For MySQL DB instances, the maximum provisioned storage limit constrains the size of a table to a maximum size of 16 TB when using InnoDB file-per-table tablespaces. This limit also constrains the system tablespace to a maximum size of 16 TB.


2 Answers

If you setup a PostgreSQL RDS instance you can query for max_connections:

select * from pg_settings where name='max_connections'; 

max_connections is set to 5696.

like image 158
sskates Avatar answered Nov 14 '22 07:11

sskates


Simply with show max_connections;

You can modify this value on the Parameter Groups on the RDS console. The value of max_connections in the default postgres9.3 Parameter Group is {DBInstanceClassMemory/12582880}. In version 9.4 the default value is {DBInstanceClassMemory/31457280}.

like image 42
Fernando Á. Avatar answered Nov 14 '22 07:11

Fernando Á.