Updated on 2024-09-24 GMT+08:00

Viewing Anomaly Snapshots

Anomaly diagnosis provides real-time health check and fault diagnosis for DB instances, collects snapshots when anomalies occur, and monitors instance performance in real time.

Diagnosis Item

Table 1 Diagnosis item

Item

Description

Transaction uncommitted

There are uncommitted transactions.

Procedure

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

    Figure 1 Anomaly Snapshots page

  7. Click on the right of Anomaly Collection to enable anomaly diagnosis.

    Figure 2 Enabling anomaly diagnosis

    After anomaly diagnosis is enabled, if the diagnosis item in Table 1 is abnormal, you can view its anomaly 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.