Real-Time sessions

The real-time session function allows you to query session snapshots of your instance and can sort out and display only the required 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.

Procedure

Log in to the management 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.

Figure 1 Searching for instances
Locate the instance you want and click Details.
Choose Sessions > Real-Time Sessions.
- On the Real-Time Sessions tab, you can view session statistics of the instance by user, host, and database.
- Select the abnormal session you want to end and click Kill for your database to recover.
- On the Slow Sessions tab page, specify Slow Session Threshold and click the refreshing button or enable Auto Refresh to search for the SQL statements whose execution time exceeds the threshold.