Performance insight (Old version)-Database Autonomy Service(DAS)-阿里云帮助中心

DAS Performance Insight (Old Version) uses simple charts to help you quickly assess database load, pinpoint performance issues, and improve database stability.

Prerequisites

The following database engines are supported:

ApsaraDB RDS for MySQL
ApsaraDB MyBase for MySQL

Notice

DAS supports Performance insight (new version). This new version enhances the original's ability to display performance trends for key metrics by using MySQL's performance_schema to aggregate SQL information. It helps you quickly locate metrics for all SQL statements, including Resource Usage, Executions, Scanned Rows, and Execution Duration. It also supports throttling and optimization for specific SQL statements.

Data sources

Performance insight (original version) collects data from the following sources:

If performance_schema is enabled on the target instance, DAS collects and analyzes data from performance_schema.
If performance_schema is disabled on the target instance, DAS collects and analyzes data from active sessions.

Procedure

Log on to the DAS console.
In the navigation pane on the left, click Intelligent O&M Center > Instance Monitoring .
Find the target instance and click the instance ID to open the instance details page.
In the left-side navigation pane, click Performance Insight.
Click Back to Previous Version to go to the previous version of the Performance Insight page.
Click Enable Performance Insight. In the dialog box that appears, click OK to enable Performance Insight.

Note
If you no longer use the Performance Insight feature, you can click Disable Performance Insight on the Performance Insight page to disable this feature.
On the Performance Insight page, select a time range and click Search.
Note
When you select a time range, ensure the end time is later than the start time:
- Performance Insight allows you to view up to seven days of data from the past month.
- Average Active Sessions allows you to view session details from the past three days.
- In the Performance Insight section, you can view the database's performance during a specific time period.
  
  To view details for a specific metric, such as Memory Usage/CPU Utilization, click Details next to the metric name.
- In the Average Active Sessions section, you can view trend charts for session categories and multi-dimensional load information to help you identify the root causes of performance issues.
  
  Click Optimize in the Actions column for the SQL category to open the SQL Diagnosis Optimization page. On this page, you can view the SQL statement, execution plan, and diagnosis result.