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.
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. To view long-running transaction sessions, contact customer service to apply for required permissions.
   Figure 1 Sessions
   

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.
   Figure 2 Setting a slow session threshold
   

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