AWS RDSDatabase

Does it affect if we increase max connections in AWS RDS for MySQL

In this blog, we explain you with an example how Does it affect if we increase max connections in AWS RDS for MySQL.
AWS RDS t2-micro running MySQL 5.5 most of the time it gives “too many connections” error. As per the DB instance type t2-micro it allows 66 maximum connections concurrently.
There is an option to increase this max DB connection value by creating a DB parameter group for this Micro instance. 

But does it affect when we increase DB connection without upgrading DB Instance type?

Each connection carries a load of per-connection buffers as set by these parametersDoes it affect if we increase max_connections in AWS RDS for MySQL
Changing the number of connections increases the amount of memory each connection can demand to this : (join_buffer_size+sort_buffer_size+read_buffer_size +read_rnd buffer_size) X max_connections
 
Amazon has to set the number of connections based on each model’s right to demand a certain amount of memory and connections.
Show More

Related Articles

One Comment

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Close