Sessions

Scenarios

You can view current session statistics of your instance, identify abnormal sessions, and kill the sessions.

Constraints

To use this function, submit a service ticket to request required permissions.

When the instance load is high, the session statistics cannot be obtained due to system traffic limiting.

Killing a session may cause service disconnection. Your applications should be able to reconnect to the instance.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Instances page, click the DB instance name.
5. In the navigation pane, choose DBA Assistant > Real-Time Diagnosis.
6. Click the Sessions tab to view current session statistics by login name, access host, and database.

   

7. In the session list, select the abnormal session you want to end and click Kill Session to recover the database.