PolarDB for MySQL quick diagnostics integrates some Database Autonomy Service (DAS) capabilities. Use session management to view session statistics for an instance.
Procedure
-
Log on to the PolarDB console.
In the upper-left corner, select the region where the cluster is deployed.
-
On the Clusters page, click the ID of the target cluster.
-
In the left-side navigation pane, choose .
-
Click the Sessions tab.
-
On the Sessions page, view details on the Instance Sessions and Session Statistics tabs.
-
Instance Sessions: Displays current sessions with key metrics such as exception count, active session count, maximum execution time, CPU utilization, and connection utilization. Available actions: Enable Auto Refresh, Export Session List, End All Sessions, and History of Ended Sessions. The session table lists details including ID, User, Host, Database, Command, Execution Time (s), State, SQL, and Transaction Duration (s).
Note-
If an abnormal parameter session occurs during an SQL request, select the session and click Kill Selected or Optimize Selected Sessions to analyze and configure the session.
-
Click 10s SQL Analysis in the upper-right corner to view the most frequently executed SQL statements and slow queries within a 10-second period. 10-second SQL analysis.
-
Click SQL throttling to limit database requests and SQL concurrency for service availability. SQL throttling.
-
-
Session Statistics: Displays session counts and durations grouped by dimension. Four sections: Overview (total sessions, running sessions, longest runtime among running sessions), By User (by database user), By Source (by client IP), and By Database (by database name). Each section shows active and total counts.
-