Lock analysis in Database Autonomy Service (DAS) lets you view and diagnose the most recent deadlock in a database instance.
Prerequisites
Before you begin, ensure that:
The database instance is connected to DAS and in the Normal Access state. For more information, see Connect a database instance to DAS.
If the instance runs PolarDB-X 2.0, the major version must be 5.4.13 or later.
Diagnose deadlocks
Log on to the DAS console.
In the left-side navigation pane, choose Intelligent O&M Center > Instance Monitoring.
Find the instance you want to manage and click its instance ID. The instance details page appears.
In the left-side navigation pane of the instance details page, click Lock Analysis.
On the Lock Analysis page, click Diagnose in the upper-left corner to check whether the instance currently has deadlocks.
Specify a time range to filter deadlock events.
In the Details column, click View Details to view the detailed diagnostic result.