In most cases, when the CPU utilization, number of active sessions, or response time of a MySQL database surges, Database Autonomy Service (DAS) first executes the SHOW PROCESSLIST statement. However, this statement may return a large number of results that are difficult to analyze. To solve this issue, DAS provides the 10-second SQL analysis feature. The system executes the SHOW PROCESSLIST statement once every two seconds within a 10-second window and then analyzes all the execution results. Based on the analysis results, you can identify the most frequently executed SQL statement and find whether the most time-consuming SQL statement exists within the 10-second window.

Procedure

  1. Log on to the DAS console.
  2. Connect a MySQL database instance to DAS. Ensure the database instance is in the Accessed state.
  3. In the left-side navigation pane, click Instance Monitoring. On the Instance Monitoring page, find the instance on which you want to perform 10-second SQL analysis.
  4. Click the instance ID to go to the instance details page.
  5. In the left-side navigation pane, click Instance Sessions, and click 10s SQL Analysis.