Updated on 2023-12-07 GMT+08:00

Daily Reports

The Daily Reports page provides overall information about your instance status of the previous day, 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

  1. Log in to the management 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 box containing your target instance and click Details.
  7. 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 diagnose the current instance. After the diagnosis is complete, view the diagnosis result.
      Figure 4 Viewing diagnosis results

      In the Inspection Scoring area, you can view the inspection score and details of the current instance. For more information about inspection scoring, see Inspection Score.

      Figure 5 Viewing inspection scoring results

      In the Slow SQL Analysis area, you can view the analysis result of slow query logs of the current instance.

      Figure 6 Slow SQL analysis

      In the All SQL Analysis area, you can view analysis of all SQL statements of the current instance.

      Figure 7 All SQL analysis

      In the Performance & Storage area, you can view performance metrics for high, medium, and low watermarks and the trend chart.

      Figure 8 Performance and storage analysis
    • Click View History to view historical reports.
      Figure 9 Viewing diagnosis history