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 in the High-availability or Enterprise Edition
  • MySQL 5.7 in the High-availability or Enterprise Edition
  • MySQL 5.6
  • MySQL 5.5

Open the Deadlock Analysis page

  1. Log on to the ApsaraDB for RDS console.
  2. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where the target RDS instance resides.
    Select a region
  3. Find the target instance and click the instance ID.
  4. In the left-side navigation pane, choose Database Autonomy Service (CloudDBA) > Diagnostics.
  5. Click the Deadlock Analysis tab.
    Deadlock Analysis
    Note For more information, see Deadlock analysis.