PolarDB for MySQL integrates with Database Autonomy Service (DAS) to provide session management, a diagnosis feature that allows you to view session statistics of an instance.
Open the Session Management page
Log on to the PolarDB console.
In the upper-left corner, select the region in which the cluster is deployed.
On the Clusters page, click the ID of the target cluster.
In the left-side navigation pane, choose Diagnostics and Optimization > Quick Diagnostics.
Click the Session Management tab.
The Session Management page contains two sections: Instance Sessions and Session Statistics.
Instance Sessions
The Instance Sessions section provides information about exceptional sessions, active sessions, and CPU usage.
You can click 10s SQL Analysis to view the most frequently executed SQL statements and slow queries within 10 seconds. For more information, see 10-Second SQL Analysis.
You can click SQL Throttling to control the number of database requests and the number of SQL concurrent requests to ensure the availability of services. For more information, see SQL Throttling.
You can click Optimize to diagnose and optimize SQL statements. For more information, see SQL optimization.
Session Statistics
The Session Statistics section provides the total number of sessions, session runtime, and other session statistics collected based on different metrics, such as the number of sessions initiated by different users.
