Daily Reports

This function allows you to initiate a health diagnosis for your instance and view overall information about the instance status, including slow SQL analysis, all SQL analysis, and performance & storage analysis. You can download and subscribe to analysis reports. Diagnosing your instance at a fixed point of time every day is recommended.

Procedure

Log in to the management console.
Click in the upper left corner and select a region and project.
Click in the upper left corner, and under Databases, click Data Admin Service.
In the navigation pane, choose Intelligent O&M > Instance List.
Alternatively, on the Overview page, click Go to Intelligent O&M.
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
Locate the box containing your target instance and click Details.
On the displayed page, choose Daily Reports.

Figure 2 Daily reports

You can perform the following operations:
- Click Download to download a diagnosis report to your local PC.
- Click Subscribe to the subscribe to daily reports. After you subscribe to daily reports, your account will be emailed when risks are identified.
  Figure 3 Subscribing to daily reports
  Before subscribing to diagnosis reports, note that:
  
  The subscription function depends on the Simple Message Notification (SMN) service.
  
  You can subscribe to daily reports by topic or by email.
  A topic is used to publish messages and subscribe to notifications. If you select by topic and the required topic is unavailable, create one first and subscribe to the topic. For details, see Creating a Topic and Adding a Subscription. Only emails are available for subscribing to topics.
  
  If you select by email, you can enter up to 15 email addresses. Separate email addresses with a semicolon (;).
  
  After you subscribe to daily reports, diagnosis reports will be emailed to you after you manually diagnose your instance and the result is abnormal.
- Click Start Diagnosis to and specify Time Range for Diagnosis to diagnose the current instance. After the diagnosis is complete, view the diagnosis result.
  Figure 4 Viewing diagnosis results
  
  In the Slow SQL Analysis area, you can view the analysis result of slow query logs of the current instance.
  
  Figure 5 Slow SQL analysis
  
  In the Performance & Storage area, you can view performance metrics for high, medium, and low watermarks and the trend chart.
  
  Figure 6 Performance and storage analysis
- Click View History to view historical reports.
  Figure 7 Viewing diagnosis history