The 10s SQL Analysis feature helps you pinpoint problematic SQL statements when a database instance triggers alerts for sudden spikes in CPU utilization, active sessions, or response time.
Prerequisites
The database instance must meet the following requirements:
-
The database instance is connected to DAS and its status is Normal Access. For more information, see Connect a database instance to DAS.
-
The database instance is one of the following types:
-
ApsaraDB RDS for MySQL
-
Self-managed MySQL
-
PolarDB for MySQL
-
PolarDB-X 2.0
-
How it works
DAS runs the show processlist command once per second for 10 seconds, then aggregates the result sets to identify the most frequently executed SQL statements and slow queries within that period.
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 Instance Sessions.
-
On the Instance Sessions page, click 10s SQL Analysis.