Help Center > > FAQs> Database Connection> What Is the Maximum Number of Connections to an RDS DB Instance?

What Is the Maximum Number of Connections to an RDS DB Instance?

Updated at: May 26, 2020 GMT+08:00

RDS does not have constraints on the number of connections. This number is determined by the default value and value range of the DB engine. For example, you can set max_connections and max_user_connections in a parameter template to configure the maximum number of connections for an RDS MySQL DB instance.

For more information, see the number of connections supported by each specification in the Relational Database Service Performance White Paper.

About max_connections

The max_connections is closely related to storage space (unit: GB) of the DB instance.

Estimated max_connections = Available node memory/Estimated memory occupied by a single connection

  • Available node memory = Total memory – Memory occupied by the buffer pool – 1 GB (mysqld process/OS/monitoring program)
  • Estimated memory usage of a single connection (single_thread_memory) = thread_stack (256K) + binlog_cache_size (32K) + join_buffer_size (256K) + sort_buffer_size (256K) + read_buffer_size (128K) + read_rnd_buffer_size (256K) = 1 MB

The following table lists the default values of max_connections for different memory specifications.

Table 1 Max_connections for different memory specifications

Memory (GB)

Connections

512

100000

384

80000

256

60000

128

30000

64

18000

32

10000

16

5000

8

2500

4

1500

2

800

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel