All Products
Search
Document Center

ApsaraDB RDS:Use the deadlock analysis feature for an ApsaraDB RDS for MySQL instance

Last Updated:Jan 22, 2024

If your ApsaraDB RDS for MySQL instance is locked, you can use the deadlock analysis feature to view and analyze the most recent deadlock of the RDS instance. The deadlock analysis feature helps locate and resolve the deadlock issue in an efficient manner and ensures the stability of your RDS instance.

Prerequisites

Your RDS instance runs one of the following MySQL versions and RDS editions:

  • MySQL 8.0 on RDS High-availability Edition, RDS Enterprise Edition, or RDS Cluster Edition

  • MySQL 5.7 on RDS High-availability Edition, RDS Enterprise Edition, or RDS Cluster Edition

  • MySQL 5.6 on RDS High-availability Edition

  • MySQL 5.5 on RDS High-availability Edition

Procedure

  1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
  2. In the left-side navigation pane, choose Autonomy Services > Diagnostics.

  3. Click the Deadlock Analysis tab.

  4. On the Deadlock Analysis tab, click Diagnose in the upper-left corner.

  5. Find the generated deadlock entry and click View Details in the Details column.

  6. In the Deadlock Analysis dialog box, check the deadlock analysis results. You can click View Deadlock Log to view the details of the most recent deadlock log.