The diagnosis feature of ApsaraDB PolarDB MySQL-compatible edition integrates with Database Autonomy Service (DAS). This allows you to view database diagnostics and optimization results on multiple tabs. On the Deadlock Analysis tab, you can analyze the latest deadlock and check the analysis details.

Procedure

  1. Log on to the PolarDB console.
  2. In the upper-left corner of the console, select the region where the cluster is deployed.
  3. On the Clusters page, find the cluster for which you want to enable the autonomy service, and click the cluster ID.
  4. In the left-side navigation pane, choose Diagnostics and Optimization > Diagnosis.
  5. Click the Deadlock Analysis tab.
    Deadlock analysis
  6. On the Deadlock Analysis tab, select a target instance ID from the Current Node drop-down list, and click Diagnose.
    Deadlock analysis
  7. Click View Details in the Details column for the latest deadlock that is detected.
    View details
    Note The View Details button is available only when the Deadlock Detected column for the same item appears in the Yes state.
  8. 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.
    Deadlock analysis