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!
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.
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.
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.
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}
.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With