In ApsaraDB RDS for MySQL, DAS provides the deadlock analysis feature. This feature allows you to view and analyze the last deadlock in a database.

Prerequisites

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

Open the Deadlock Analysis page

  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 Database Autonomy Service (CloudDBA) > Diagnostics.
  3. Click the Deadlock Analysis tab.
    Deadlock Analysis
    Note For more information, see Deadlock analysis.