Managing Real-Time Sessions

Scenarios

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

Constraints

Killing a session may cause the application to disconnect from the instance. Your application should be able to reconnect to the instance.

Setting a Slow Session Threshold

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > TaurusDB.
4. On the Instances page, click the 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.
   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. Too long SQL statements will be truncated and displayed in the session list.
   Figure 2 Setting a slow session threshold
   

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

   A maximum of 20 sessions can be killed at a time.

   To kill sessions automatically, see Configuring Auto Throttling.