All Products
Search

This Product

    PolarDB:Deadlock analysis

    Document Center

    PolarDB:Deadlock analysis

    Last Updated:Sep 13, 2023

    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. In the upper-left corner of the console, select the region in which the cluster that you want to manage 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.

    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