Help Center/ Relational Database Service/ FAQs/ Database Connection/ What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?
Updated on 2024-10-08 GMT+08:00
View PDF
Share

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

  1. Check whether applications are connected, optimize the connections, and release unnecessary connections.
  2. Check the specifications and scale them up if needed.
  3. 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

  1. Connect to a DB instance through a private network. Using a private network prevents congestion caused by insufficient bandwidth.
    Follow the steps provided in:
  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.
Parent topic: Database Connection