Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

value of max_connections in AWS 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