Intelligent Database Diagnosis

Procedure

1. Log in to the Huawei Cloud console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner. Choose Databases > 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 address.
6. Click the Performance tab.
   • AI-based anomaly detection

     DAS detects abnormal performance metrics and marks them in red. You can focus on the anomalies during issue analysis. AI anomaly detection is enabled by default. You can toggle on or off Enable AI Anomaly Detection in the upper right corner.

     Figure 1 AI anomaly detection
     
   • Select a period close to the time when the anomaly occurred for fault locating and analysis.
     After clicking , you can drag the cursor in the chart to select a period close to the time when the anomaly occurred. In the displayed dialog box, click Analyze. The analysis details page is displayed.

     Figure 2 Fault locating and analysis
     
     The analysis details include analysis results of risks, associated SQL queries, slow query logs, and top SQL queries. In the Associated SQL Analysis area, SQL templates closely related to metric changes are displayed.

     Figure 3 Analysis details