The diagnosis feature of PolarDB for MySQL 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. On the top of the page, select the region where the target cluster is located.
  3. In the left-side navigation pane, click Clusters to go to the Clusters page, and click the target cluster ID. The Overview page appears.
  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