Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

value of max_connections in AWS RDS

Tags:

database

mysql

amazon-web-services

rds

does anyone know where I can found the highest value of max_connections in AWS RDS? I'm primarily interested in the db.t2 instances running MySQL. I cannot find any appropriate link about that. Thanks!!

like image 803
Jacob Avatar asked Sep 26 '16 14:09

Jacob

People also ask

What is Max_connections?

max_connections is a global variable that can have a minimum value of 1 and a maximum value of 100000. However, It has always been commonly known that settings max_connections to an insanely high value is not too good for performance. Generations of system administrators have followed this rule.

What is the maximum size RDS volume?

You can now create Amazon RDS for SQL Server database instances with up to 16TB of storage, up from 4TB.

2 Answers

As @error2007s states you can find it in the console, just to complete, in a more general way you have:

  • t2.micro 66
  • t2.small 150
  • m3.medium 296
  • t2.medium 312
  • m3.large 609
  • t2.large 648
  • m4.large 648
  • m3.xlarge 1237
  • r3.large 1258
  • m4.xlarge 1320
  • m2.xlarge 1412
  • m3.2xlarge 2492
  • r3.xlarge 2540

Taken from here

like image 131
imTachu Avatar answered Oct 23 '22 10:10

imTachu

When you go to configuration details of your RDS you will find a Parameter Group in the details. Click on that parameter group.

enter image description here

In that parameter group search for max_connections you will get the value.

enter image description here

like image 4
error2007s Avatar answered Oct 23 '22 11:10

error2007s
Sign in to Comment

Related questions

Display dynamic ranges from a database table and count the rows within each range
SNMP OUTPUT OPTIONS - How do I get the OID response value only?
Where can I find the SQL files of XAMPP in Linux?
Laravel 5: syncing an extra field via pivot
How to SELECT * and rename a column?
How to get last day of month in mysql by giving month and year as input
How to perform table/row locks in Django
Creating migrations for stored procedures, functions and events from existing database in Laravel
Is it okay to have non sequential ids as primary keys for a table in your database?
mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid prevent from server restart
Price rules database design for hotel reservation system
Store mysql result in a bash array variable
MYSQL: Query order by rand() very slow
MYSQL table and column naming convention
Can't DROP TABLE because unknown table (ERROR 1051)
mysql / php: find starting string within string
Boolean type on mysql
How can i insert real time of an event into database using php mysqli?
SQLSTATE[HY000] [2002] Establishing tcp connections on remote port 3306 has been disabled for security reasons
Getting error while executing criteria query on enum column in mysql table hibernate

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!