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. Visit the RDS instance list, select a region above, and click the target instance ID.
  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.