This topic provides an overview of the Report function in RDS for MySQL. With this function, you can manually diagnose your RDS for MySQL instance, enable the system to automatically diagnose the instance, and view the instance health, alarms, and slow SQL statements.

Prerequisites

The MySQL version and RDS edition are as follows:
  • MySQL 8.0 High-availability Edition
  • MySQL 5.7 High-availability Edition/Enterprise Edition
  • MySQL 5.6
  • MySQL 5.5

Create a diagnostic report

  1. Log on to the RDS console.
  2. Select the target region.
    Select a region
  3. Find the target RDS instance and click the instance ID.
  4. In the upper-left corner, choose CloudDBA > Report.
  5. Enable the system to automatically create a diagnostic report, or manually create a diagnostics report.
    To enable the system to automatically create a diagnostic report, follow these steps:
    1. In the upper-left corner, click Auto-Generating Report Settings.
      Auto-Generating Report Settings button
    2. Set the auto-generating cycle (one or more days within a week) and time.
      Note
      • Currently only the Scheduled Trigger function is supported.
      • Diagnostic reports may be generated at a certain latency due to reasons such as task scheduling and heavy load.
      Auto-Generating Diagnostic Report Settings dialog box
    To manually create a diagnostic report, follow these steps:
    1. In the upper-left corner, click Diagnose.
    2. In the displayed dialog box, select a time range and click OK.
      Note The time range must span less than two hours.

View a diagnostic report

After the diagnosis is completed, you can click View Report in the Actions column to view the report details. The following table describes the parameters in the report.

Note You can click Download in the lower-left corner to save the report to your computer.
Parameter Description
Basic Information The basic information, such as the instance ID, specifications, and DB engine.
Health Status Summary The maximum, minimum, and average values of CPU, IOPS, storage capacity, and number of active sessions within the specified time range.
Alerts The information about the alerts generated within the specified time range. The alert information includes the alert-triggering rules, monitoring metrics, occurrence time, and duration.
Active Sessions The sessions that are active within the specified time range. The session information includes the session IDs, users, hosts, databases, and SQL statements.
Top 5 Slow SQL Statements The top 5 slow SQL statements that are run for a large number of times within the specified time range. The slow SQL statement information includes the SQL statement samples, database names, execution counts, and average required time.
TOP 5 Table Spaces The top 5 tables that take the most space within the specified time range. The table information includes the table names, database names, DB engines, and tablespaces.
CPU The changes to CPU usage within the specified time range.
IOPS The changes to IOPS within the specified time range.
QPS and TPS The changes to QPS and TPS within the specified time range.
Sessions The changes to sessions within the specified time range.
Storage Changes The changes to space usage within the specified time range.
Diagnostic Report Details