View the deadlock history

This topic describes how to view the deadlock history.

You can view deadlock analysis information by using the following methods:

• Method 1

  Log on to the OceanBase Cloud Platform (OCP) console and go to the Overview page of the target tenant. In the left-side navigation pane, click Session Management and then go to the View Deadlock History tab.

• Method 2

  Log on to the OCP console and go to the Real-time Diagnostics page. Click Session Management and then go to the View Deadlock History tab.

Prerequisites

• You have the permissions to manage tenants.

• Automatic detection of deadlocks has been enabled for the cluster where the tenant is located. For more information, see Enable automatic detection of deadlocks.

Procedure

The procedure of Method 2 is described as follows:

1. Log on to the OCP console.

2. In the left-side navigation pane, click OceanBase Autonomy Service.

3. In the Cluster Details section, click the name of the cluster that you want to view.

4. Go to the Session Management tab on the Real-time Diagnostics page.

5. Click the View Deadlock History tab and view the historical deadlock information.