Help Center > > FAQs> Database Connection> What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?

What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?

Updated at: Jun 09, 2021 GMT+08:00

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

  1. Check whether applications are connected, optimize the connections, and release unnecessary connections.
  2. Check the specifications and scale them up if needed.
  3. Check whether any metrics are abnormal and whether any alarms are generated on the Cloud Eye console. Cloud Eye monitors database metrics, such as the CPU usage, memory usage, storage space usage, and database connections, and allows you to set alarm policies to identify risks in advance if any alarms are generated. For details, see the Cloud Eye User Guide.

Solution

  1. Connect to a DB instance through a private network. Using a private network prevents congestion caused by insufficient bandwidth.
  2. On the management console, set the parameter innodb_adaptive_hash_index to off to reduce lock wait time. For operation details, see Modifying Parameters.
  3. Optimize slow queries.

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