Database Autonomy Service (DAS) provides the performance insight feature. The original version of the feature provides charts and tables to help you evaluate database workloads and identify the root causes of database performance issues. This improves the stability of your databases.

Prerequisites

The database instance that you want to manage is of one of the following types:
  • ApsaraDB RDS for MySQL
  • ApsaraDB MyBase for MySQL
  • ApsaraDB RDS for PostgreSQL
  • PolarDB for MySQL
  • PolarDB for PostgreSQL
  • PolarDB for PostgreSQL (Compatible with Oracle)

Usage notes

DAS supports the new version of the performance insight feature. Like the original version, the new version allows you to view the trends of key performance metrics. In addition, the new version aggregates the statistics on SQL statements based on the capabilities of the Performance Schema feature provided by MySQL to help you identify the resource consumption, number of executions, number of scanned rows, and execution duration of all SQL statements. The new version also performs throttling and optimization on the specified SQL statements. For more information about the new version of the feature, see Performance insight (new version).

Data sources

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

Procedure

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Instance Monitoring.
  3. On the page that appears, find the database instance that you want to manage and click the instance ID. The instance details page appears.
  4. In the left-side navigation pane, click Performance Insight.
  5. On the page that appears, click Back to Previous Version. Back to Previous Version
  6. On the Performance Insight tab, click Enable Performance Insight. In the message that appears, click OK to enable the performance insight feature.
    Note If you no longer use the performance insight feature, you can click Disable Performance Insight on the Performance Insight tab to disable this feature.
  7. In the Performance Insight section, specify a time range and then click Search to view the database 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 database 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 database instance, click Details on the right side 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 database workloads from multiple dimensions. This can help you identify the root causes of performance issues. aa