Database Autonomy Service (DAS) provides the diagnostic reports feature for ApsaraDB RDS for MySQL. This feature can be used if the system detects performance issues on your ApsaraDB RDS for MySQL instance or performs routine inspections. This feature allows you to create a diagnostic report to evaluate the status of your RDS instance within a specified period of time. This way, you can identify exceptions on your RDS instance at the earliest opportunity based on statistics such as slow query logs, tablespaces, and the performance trend in the diagnostic report.
Prerequisites
Your RDS instance runs MySQL.
Your RDS instance does not run RDS Basic Edition.
Procedure
- Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the left-side navigation pane, choose .
Click Create Reports.
Click Auto-generating Report Settings. In the dialog box that appears, configure the parameters in the Scheduled Trigger section to automatically generate diagnostic reports.
NoteThe time range that you specify cannot exceed one day. If you specify a shorter time range, more detailed statistics are collected in diagnostic reports.
Refresh the page to view the diagnostic progress. After the diagnostic task is complete, find the diagnostic report that you want to view and click View Report in the Actions column to view the details of the report, including the score. For more information about scoring rules, see Scoring rules.
References
If issues such as slow SQL queries occur on your RDS instance, you can use the features that are described in the following topics to resolve the issues:
If issues related to storage capacity occur on your RDS instance, you can use the features that are described in the following topics to resolve the issues:
If performance issues occur on your RDS instance, you can use the features that are described in the following topics to resolve the issues: