DAS supports performance insight (original version), which uses simple charts to help you quickly assess the load on your target database, identify performance bottlenecks, and improve database stability.
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 .
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 open the performance insight (original version) page.
-
Click Enable Performance Insight. In the dialog box that appears, click OK to enable Performance Insight.
NoteTo disable this feature, click Disable Performance Insight on the Performance Insight page.
-
On the Performance Insight page, select a time range and click Search.
NoteWhen 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.
-