Performance insight (Old version)

Notice

DAS now supports Performance Insight (New Version). Building on the capabilities of the old version, the new version uses MySQL's Performance Schema to aggregate SQL information. This allows you to quickly identify metrics for all SQL statements, including Resource Usage, Executions, Scanned Rows, and Execution Duration. You can also throttle and optimize target SQL statements.

Data sources

Procedure

1. Log on to the DAS console.

2. In the navigation pane on the left, click Intelligent O&M Center > Instance Monitoring .

3. Find the target instance and click the instance ID to open the instance details page.

4. In the left-side navigation pane, click Performance Insight.

5. Click Back to Previous Version to go to the previous version of the Performance Insight page.

6. 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.

7. On the Performance Insight page, select a time range and click Search.

   Note

   When you select a time range, the end time must be later than the start time:

   • You can use Performance Insight to view data for up to seven days within the past month.

   • You can use Average Active Sessions to view session data from the last three days.

   • The Performance Insight area displays database performance over the selected period.

     To view the details of a specific performance metric, such as Memory Usage/CPU Utilization, click Details next to the metric name.

   • In the Average Active Sessions area, you can view trend charts for different session categories and a multi-dimensional load breakdown to identify the source of performance issues.

     In the SQL category, click Optimize in the Actions column to open the SQL Diagnosis Optimization page, which displays the corresponding SQL statement, execution plan, and diagnosis result.

     

FAQ