Database Autonomy Service (DAS) provides the performance snapshot feature. You can use this feature to solve the following issue:
- Log on to the DAS console.
- An ApsaraDB RDS for MySQL database instance is connected to DAS and is in the Accessed state.
- In the left-side navigation pane, click Instance Monitoring. Find the instance and click its ID to go to the instance details page.
- Click Performance Snapshot.
- To enable the performance snapshot feature, click the Settings icon that is framed by the red rectangle in the following
figure. If no alert rules are configured to monitor the active sessions of MySQL instances, click the link in the Alert Configuration Required message. On the Alert Configuration
page, configure the alert settings.
- Click OK.Note As shown in the preceding figure, a snapshot is created for the ApsaraDB RDS for MySQL instance if the number of consecutive active sessions is greater than or equal to 23.
- Select the snapshot that you want to view and click Search in the Actions column.
- The snapshot details page appears.
- The Monitoring within Seconds section shows the monitoring data of key metrics based on seconds.
- The next section shows the following information:
- The active session statistics collected within 60 seconds after the performance snapshot feature is enabled. The active session statistics are collected by executing the SHOW FULL PROCESSLIST statement every second. The statistics help you identify the most frequently executed SQL statement, the most time-consuming SQL statement, top users, top sources, top commands, and top sessions.
- The full request statistics collected within 60 seconds after the performance snapshot feature is enabled. The statistics can be collected only after you enable the SQL Explorer feature.
- The slow query log statistics collected within 60 seconds after the performance snapshot feature is enabled.