Managing Real-Time Sessions

Scenarios

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

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 > GaussDB(for MySQL).
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.
   Figure 2 Setting a slow session threshold
   
   

   Too long SQL statements will be truncated and displayed in the session list.

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 Flow Control.