AWS RDS connection limits

AWS RDS max_connections limit variable is based on Instance type, so you can upgrade your RDS or make more replica.

The RDS types with max_connections limit:

  • 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

Referring by max_connections at AWS RDS MySQL Instance Sizes in 2015

Update 2017-07

The current RDS MySQL max_connections setting is default by {DBInstanceClassMemory/12582880}, if you use t2.micro with 512MB RAM, the max_connections could be (512*1024*1024)/12582880 ~= 40, and so on.

Each Web server could have many connections to RDS, which depends on your SQL requests from Web server.

Related Posts:

  1. AWS Lambda:The provided execution role does not have permissions to call DescribeNetworkInterfaces on EC2
  2. AWS – Disconnected : No supported authentication methods available (server sent :publickey)
  3. What is difference between Lightsail and EC2?
  4. What is the difference between Amazon SNS and Amazon SQS?
  5. AWS: What does 0.0.0.0/0 and ::/0 mean?
  6. What is the difference between Elastic Beanstalk and CloudFormation for a .NET project?
  7. How can I resolve the error “The security token included in the request is invalid” when running aws iam upload-server-certificate?
  8. DynamoDB – Key element does not match the schema
  9. How to improve paralelized computing in AWS EC2?
  10. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  11. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  12. AWS CLI S3 A client error (403) occurred when calling the HeadObject operation: Forbidden
  13. 403 ERROR The request could not be satisfied
  14. How can I get the size of an Amazon S3 bucket?
  15. What is the difference between Amazon ECS and Amazon EC2?
  16. MySQL equivalent of DECODE function in Oracle
  17. How to create a foreign key in phpmyadmin
  18. what is the difference between triggers, assertions and checks (in database)
  19. Difference between AWS DynamoDB vs. AWS DocumentDB(Newly launched service)? [closed]
  20. Detecting errors generated by $wpdb->get_results()
  21. wpdb update add current timestamp not working
  22. How do I make an HTML table from a database table?
  23. Displaying content from one WP site on separate WP site
  24. Lost the `wp_options` table: what’s the best way to restore the site?
  25. Performance Gains of Relational DB Setup
  26. Getting wrong relationship value in $args in wp_Query?
  27. How to move existing WordPress wp-content folder along with database to new server and new domain name?
  28. store simple data in get_option()
  29. How might I retrieve a featured post image from an external WP site and display it as a link back?
  30. What are conventions about the schema of the $table_prefix
  31. How to modify post content before writing to database?
  32. Does WordPress cache get_user_meta() results?
  33. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  34. What is an efficient way to query based on post_meta?
  35. Why WordPress uses 4 tables to manage terms
  36. prefix table and plugins
  37. Database slowdown after update to 3.4.1
  38. How to insert data into MySQL database from the form created in WordPress site
  39. How to find the output of contact form 7 shortcode? [closed]
  40. Which is best in the following scenario : post_meta vs custom table vs parent/child posts
  41. What for the tables ending with the meta used in database of wordpress?
  42. Emoji support and MariaDB 10.0.30-
  43. Change setting name in Customizer and keep the data
  44. How do I copy a wordpress database?
  45. Modify Database in Multi-Site wp_usermeta table
  46. Form Data not getting stored in WordPress database
  47. Hook directly into query execution
  48. $wpdb doesn’t like to store arrays
  49. Connect to a remote database for wordpress in my own hosting server
  50. How to access data in wordpress database externally using php
  51. WordPress ‘comment counts’ got messed up, because of a plugin – DISQUS
  52. What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
  53. Importing CSV into database table not working?
  54. Will changing the folder name two directories above a fresh wordpress installation break the site?
  55. database sent to a JSON file
  56. Share DB tables between two blogs on the same WP Multisite installation
  57. When open add new post or page WordPress add post with ID=0 continuously [closed]
  58. Delete data from database using row action
  59. Export a custom Mysql database product catalog to WordPress
  60. Is it safe to have 2 mysql users?
  61. Any risk to changing WP table col CHARACTER_MAXIMUM_LENGTH?
  62. How to add an external php page with wordpress?
  63. Applying WP-cli Search & Replace to Static SQL Dump File
  64. How can I find the cause of a 500 server error?
  65. I can’t update my data through $wpdb
  66. Should I store critical css in the database or in my theme’s filesystem?
  67. Wpdb get->results to out the the month from the db
  68. WordPress plugin boilerplate table create
  69. Is it risky if I update all url in the database due to my site url changed?
  70. How to share User Database between Two Multisite Installations + More
  71. different theme in one website
  72. database not responding on localhost
  73. Need help fixing sql syntax error after WP 3.2 upgrade
  74. Need help with creating a searchable user data by name or specific number like ID
  75. Switching among theme customizations
  76. How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
  77. Creating a custom form with ability to query and submit to SQL
  78. Can I use a wpdb object to connect to a non-WordPress Oracle database [duplicate]
  79. Error: SHOW FULL COLUMNS FROM `pt_participant`
  80. WordPress database issues – menu not saving correctly, media thumbnails not showing
  81. update to a new template without loosing any data
  82. Why aren’t my posts being saved or published?
  83. Form display in new page
  84. Maximum number of posts per page before affecting performance?
  85. Locally installing wordpress. Database problem
  86. I have my full special database from xampp how can i use this on wordpress?
  87. Halting data inserts for future refresh of post?
  88. Possible to restore wordpress database from mysql56 and sqlite files?
  89. Multi-site database upgrade claims success, but db_version not updated
  90. Processing a lot of $wpdb isn’t insert all the data
  91. option select form always deleting the sql query
  92. Displaying database table in backend of wordpress
  93. How can I safely delete data related to wp_post table manually from the mysql database?
  94. WP Posts Not Adding Up
  95. Changing database links has no effect
  96. Update references to pictures on website after moving to new URL
  97. wpdb get_var is not returning any result (verified mysql query returns only one value)
  98. database search feature
  99. Restrict users viewing post using age on database [closed]
  100. What’s the cleanest way to transfer WordPress to a new server

Leave a Comment