Managing Anomaly Snapshots

Scenarios

This function intelligently detects instance anomalies and records information about session, lock, and transaction snapshots to facilitate subsequent fault locating.

Constraints

• To use this function, contact customer service to apply for required permissions.
• Enabling anomaly collection will cause about 5% of instance performance loss.
• For an HA read replica with anomaly snapshots enabled, if the primary read replica node fails and workloads are automatically switched over to the standby read replica node, anomaly snapshots will not be enabled for the new primary read replica node.
• Each anomaly snapshot can be retained for a maximum of seven days. A maximum of 10 anomaly snapshots can be retained for each node at the same time.
• Anomaly snapshots record long-running transactions.

Enabling Anomaly Collection

1. Log in to the DAS console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner, and under Databases, click Data Admin Service.
4. In the navigation pane, choose Intelligent O&M > Instance List.

   Alternatively, on the Overview page, click Go to Intelligent O&M.

5. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.
   Figure 1 Searching for instances
   

6. Locate the target instance and click Details.
7. Click the Anomaly Snapshots tab.
8. On the displayed page, toggle on the Anomaly Collection switch.
   Figure 2 Anomaly Snapshots
   

Viewing Anomaly Snapshots

1. Click the Anomaly Snapshots tab.
2. On the displayed page, view session snapshots, metadata lock snapshots, InnoDB lock snapshots, and transaction snapshots of the DB instance.
   • To view anomaly causes, click Diagnosis Details in the Operation column.
   • To view details about slow SQL statements, click Slow SQL in the Operation column.