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.

Managing Real-Time Sessions

1. Log in to the TaurusDB console.
2. Click in the upper left corner and select a region and project.
3. On the Instances page, click the instance name.
4. In the navigation pane, choose Sessions under DBA Assistant.
5. In the session statistics, you can view statistics on the slow sessions, active sessions, total sessions, long transaction sessions by user, access host, and database.
   Figure 1 Real-time sessions
   

6. Click next to the Slow Session Threshold field. In the displayed dialog box, set a slow session threshold and click OK. Sessions whose execution durations are greater than this threshold are automatically displayed.
   Figure 2 Setting a slow session threshold
   

7. On the Sessions tab page, view session details. You can also select the abnormal sessions you want to terminate and click Kill Session to recover databases.

   A maximum of 20 sessions can be terminated at once.

   To kill sessions automatically, see Using Auto Kill Sessions.