Managing Real-Time Sessions

Scenarios

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

Setting Slow Session Threshold

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
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 user, access host, and database.

   

7. Click Set Slow Session Threshold. In the displayed dialog box, configure Max. Execution Time for a Query (s) and click OK. Sessions whose execution time exceeds the threshold are automatically displayed.

   

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