What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?
The number of database connections indicates the number of applications that can be simultaneously connected to a database, and is irrelevant to the maximum number of users allowed by your applications or websites.
If there is an excessive number of database connections, applications may fail to be connected, and the full and incremental backups may fail, affecting services.
Fault Locating
- Check whether applications are connected, optimize the connections, and release unnecessary connections.
- Check the specifications and scale them up if needed.
- On the Cloud Eye console, view metrics of your DB instance to identify performance issues and set alarms for metric thresholds. Cloud Eye monitors metrics of different categories, including CPU, memory, storage, and connections. For details, see the Cloud Eye User Guide.
Solution
- Connect to a DB instance through a private network. Using a private network prevents congestion caused by insufficient bandwidth.
- On the management console, set the parameter innodb_adaptive_hash_index to off to reduce lock wait time. For operation details, see Modifying Parameters.
- Optimize slow queries.
Database Connection FAQs
- What Should I Do If I Can't Connect to My RDS DB Instance?
- Can an External Server Access the RDS Database?
- What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?
- What Is the Maximum Number of Connections to an RDS DB Instance?
- How Can I Create and Connect to an ECS?
- What Should I Do If an ECS Cannot Connect to an RDS DB Instance Through a Private Network?
- What Should I Do If a Database Client Problem Causes a Connection Failure?
- What Should I Do If an RDS Database Problem Causes a Connection Failure?
- How Do My Applications Access an RDS DB Instance in a VPC?
- Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
- Why Cannot I Ping My EIP After It Is Bound to a DB Instance?
- How Can I Obtain the IP Address of an Application?
- What Should I Do If an RDS for SQL Server DB Instance Failed to Be Connected?
- Can I Access an RDS DB Instance Over an Intranet Connection Across Regions?
- Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover?
- Will My Access Be Restricted by Bandwidth When I Connect to My Instance from an ECS over a Private Network?
- Why Did the New Password Not Take Effect After I Reset the Administrator Password?
- Will I Be Logged Out If the Connection to RDS for SQL Server Instances Times Out?
- How Do I Set the Encoding Format of the MySQL 8.0 Character Set?
- What Should I Do If the ECS and RDS Are Deployed in Different VPCs and They Cannot Communicate with Each Other?
- How Do I View All IP Addresses Connected to a Database?
- Can I Access Standby RDS DB Instances?
- How Do I Check the Connections to an RDS for MySQL Instance?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore