All Products
Search

This Product

    Database Autonomy Service:Deadlock analysis

    Document Center

    Database Autonomy Service:Deadlock analysis

    Last Updated:Nov 14, 2023

    Database Autonomy Service (DAS) provides the deadlock analysis feature. You can view and analyze the last deadlock in a database. This topic describes how to use the deadlock analysis feature.

    Prerequisites

    • If your database instance runs PolarDB-X 2.0, the major version of the instance must be 5.4.13 or later.

    • Your database instance is connected to DAS and is in the Normal Access state. For more information, see Connect a database instance to DAS.

    Procedure

    1. Log on to the DAS console.
    2. In the left-side navigation pane, click Instance Monitoring.
    3. On the Instance Monitoring page, find the instance that you want to manage and click the instance ID.
    4. In the left-side navigation pane of the instance details page, click Deadlock Analysis.
    5. On the Deadlock Analysis page, click Diagnose in the upper-left corner.
    6. Find the generated deadlock entry, and click View Details in the Details column.
    7. In the Deadlock Analysis dialog box, check the deadlock analysis results. You can click View Deadlock Log to view the details of the last deadlock log.