When CPU utilization, active sessions, or response time spike on a database instance, use 10-second SQL analysis to identify the SQL statements driving the problem—without waiting for a slow query log or a full profiling session.
Supported database types
10-second SQL analysis is available for the following database instance types:
ApsaraDB RDS for MySQL
Self-managed MySQL databases
PolarDB for MySQL
PolarDB-X 2.0
The database instance must be connected to DAS and in the Normal Access state. For more information, see Connect a database instance to DAS.
How it works
DAS runs SHOW PROCESSLIST once per second for 10 consecutive seconds, then analyzes the 10 result sets together. The analysis surfaces:
The SQL statements executed most frequently during the 10-second window
Whether any slow queries exist within that window
Run a 10-second SQL analysis
Log on to the DAS console.
In the left-side navigation pane, click Instance Monitoring.
Find the database instance and click its instance ID.
In the left-side navigation pane, click Instance Sessions.
On the Instance Sessions page, click 10s SQL Analysis.