Sessions

You can query, sort, and filter database session snapshots. You can quickly search for slow or active sessions in multiple dimensions like users, host IP addresses, and database names. DAS allows you to kill sessions to restore your instance, securing your database availability.

Usage Notes

Killing a session may cause instance or service exceptions.

Procedure

Log in to the console.
Click in the upper left corner and select a region and project.
Click in the upper left corner, and under Databases, click Data Admin Service.
In the navigation pane, choose Intelligent O&M > Instance List.

Alternatively, on the Overview page, click Go to Intelligent O&M.
In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.
Locate the target instance and click Details.
On the Sessions tab page, perform the following operations:
- View session statistics.
  You can view statistics on slow, active, and total sessions by username, access host, and database.
  
  Statistics can be collected by host and port or by host.
- Set a slow session threshold.
  Click Set Slow Session Threshold. In the displayed dialog box, set Max. Execution Time for a Query (s) and click OK. Sessions whose execution time exceeds the threshold are automatically displayed in the session list.
- Killing sessions
  In the session list, you can view session details. You can also select the abnormal session you want to end based on session status and service requirements and click Kill Session to recover the database.
- Exporting sessions
  In the session list, click Export to export session details.