Help Center/
Relational Database Service_RDS for MySQL/
User Guide/
Problem Diagnosis and SQL Analysis/
Problem Diagnosis/
Managing Anomaly Snapshots
Updated on 2025-08-20 GMT+08:00
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
- 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.
Procedure
- Click
in the upper left corner and select a region.
- Click
in the upper left corner of the page and choose Databases > Relational Database Service.
- On the Instances page, click the target instance name.
- In the navigation pane, choose DBA Assistant > Historical Diagnosis.
- Click the Anomaly Snapshots tab.
- On the displayed page, toggle on the Anomaly Collection switch.
Figure 1 Anomaly Snapshots
- Click the Anomaly Snapshots tab.
- 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. For details, see Viewing Slow Query Logs of a DB Instance.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot