What Is the Maximum Number of Connections to a GaussDB(for MySQL) Instance?
GaussDB(for MySQL) 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 a GaussDB(for MySQL) instance.
Changing the Maximum Number of Connections
The number of connections can be changed online. For details, see Modifying a Parameter Template.
You can run commands to change the maximum number of connections.
About max_connections
max_connections indicates the maximum number of clients that can be connected at the same time. If this parameter is set to default, it is related to the instance memory (unit: GB). The calculation formula is as follows:
Estimated value of 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, and monitoring program)
- Estimated memory usage of a single connection (single_thread_memory) = thread_stack (256 KB) + binlog_cache_size (32 KB) + join_buffer_size (256 KB) + sort_buffer_size (256 KB) + read_buffer_size (128 KB) + read_rnd_buffer_size (256 KB) ≈ 1 MB
The following table lists the default values of max_connections for different memory specifications.
Memory (GB) |
Connections |
|---|---|
512 |
100,000 |
384 |
80,000 |
256 |
60,000 |
128 |
30,000 |
64 |
18,000 |
32 |
10,000 |
16 |
5,000 |
8 |
2,500 |
4 |
1,500 |
2 |
800 |
Database Connections FAQs
- Can an External Server Access the GaussDB(for MySQL) Database?
- What Do I Do If the Number of GaussDB(for MySQL) Database Connections Reaches the Upper Limit?
- What Is the Maximum Number of Connections to a GaussDB(for MySQL) Instance?
- What Should I Do If an ECS Cannot Connect to a GaussDB(for MySQL) Instance?
- How Can I Connect to a MySQL Database Through JDBC?
- How Can I Create and Connect to an ECS?
- What Should I Do If a Database Client Problem Causes a Connection Failure?
- Why Cannot I Ping My EIP After It Is Bound to a DB Instance?
- What Can I Do If the Connection Test Failed?
- Can I Access a GaussDB(for MySQL) Instance over an Intranet Connection Across Regions?
- Are There Any Potential Risks If There Are Too Many Connections to a GaussDB(for MySQL) Instance?
- What Should I Do If an ECS and a GaussDB(for MySQL) instance Deployed in Different VPCs Cannot Communicate with Each Other?
- How Do I View All IP Addresses Connected to a Database?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
more
