Viewing Anomaly Snapshots

After anomaly diagnosis is enabled, the system checks your instance health status and diagnoses faults. If there is an anomaly, its snapshots will be collected, helping you monitor instance performance in real time.

Diagnosis Item

**Table 1** Diagnosis item
Item	Description
Transaction uncommitted	There are uncommitted transactions.

Procedure

Log in to the management console.
Click in the upper left corner and select a region and project.
Click in the upper left corner of the page and choose Databases > GaussDB(for MySQL).
On the Instances page, click the instance name.
In the navigation pane, choose DBA Assistant > Historical Diagnosis.
Click Anomaly Snapshots.

Figure 1 Anomaly Snapshots page
Click on the right of Anomaly Collection to enable anomaly diagnosis.

Figure 2 Enabling anomaly diagnosis

After anomaly diagnosis is enabled, if any anomaly listed in Table 1 occurs, you can view its snapshots. Anomaly snapshot records are retained for seven days and will be deleted after this time expires. A maximum of 100 records can be retained for a single node.

Click Diagnosis Details in the Operation column to view diagnosis result details and optimization suggestions.

Click the Anomaly Snapshots tab to view session snapshots, metadata lock snapshots, InnoDB lock snapshots, and transaction snapshots.