Database Autonomy Service (DAS) provides the original performance insight feature for ApsaraDB RDS for MySQL. The original performance insight feature supports load monitoring, association analysis, and performance tuning for your ApsaraDB RDS for MySQL instance. This feature allows you to quickly evaluate the loads on the RDS instance and identify the root causes of performance issues. This helps increase the stability of your database system.

Prerequisites

Your RDS instance must run one of the following MySQL versions and RDS editions:
  • MySQL 8.0 on RDS High-availability Edition or RDS Enterprise Edition
  • MySQL 5.7 on RDS High-availability Edition or RDS Enterprise Edition
  • MySQL 5.6 on RDS High-availability Edition
  • MySQL 5.5 on RDS High-availability Edition

Usage notes

DAS provides the new performance insight feature for ApsaraDB RDS for MySQL. Compared with the original performance insight feature, the new performance insight feature collects statistics on SQL statements based on the Performance Schema feature of MySQL. This way, you can quickly view the resource usage, number of executions, number of scanned rows, and execution duration of all SQL statements. In addition, the new performance insight feature allows you to throttle and optimize the specified SQL statements. For more information, see Use the new performance insight feature for an ApsaraDB RDS for MySQL instance.

Data sources

The original performance insight collects and analyzes data from the following major sources:
  • If the Performance Schema feature is enabled for your RDS instance, the original performance insight collects and analyzes data stored in the Performance Schema feature.
  • If the Performance Schema feature is disabled for your RDS instance, the original performance insight feature collects and analyzes the data of active sessions.

Procedure

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, choose Autonomy Service > Performance Insight.
  3. On the page that appears, click Back to Previous Version. Return to old version
  4. On the page that appears, click Enable Performance Insight. In the message that appears, click OK.
    Note If you no longer require the performance insight feature, you can click Disable Performance Insight on the Performance Insight page.
  5. In the Performance Insight section, specify a time range and then click Search to view the performance metrics within the specified period.
    Note When you select a time range, the end time must be later than the start time.
    • Data generated in up to seven days within the last month are displayed in the Performance Insight section.
    • The information about sessions in the last three days is displayed in the Average Active Session section.
    • In the Performance Insight section, you can specify a time range to view the performance metrics within the specified period. You can view the details of a specific performance metric. For example, if you want to view the CPU utilization of the RDS instance, click Details to the right of Memory Usage/CPU Utilization. ss
    • In the Average Active Session section, you can view the trends of different types of sessions, such as sessions that are created to execute SQL statements. You can also view the instance loads from multiple dimensions. This helps you identify the root causes of performance issues. aa