Database Autonomy Service (DAS) provides the deadlock analysis feature for ApsaraDB RDS for MySQL. This feature allows you to view and analyze the latest deadlock of an ApsaraDB RDS for MySQL instance.

Prerequisites

Your RDS instance runs one of the following MySQL versions and RDS editions:
  • MySQL 8.0 on RDS High-availability Edition or RDS Enterprise Edition
  • MySQL 5.7 on RDS High-availability Edition or RDS Enterprise Edition
  • MySQL 5.6 on RDS High-availability Edition
  • MySQL 5.5 on RDS High-availability Edition

Procedure

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, choose Autonomy Service > Diagnostics.
  3. Click the Deadlock Analysis tab.
  4. In the upper-left corner of the Deadlock Analysis tab, click Diagnose.
  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 latest deadlock log.