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 a project.
3. Click in the upper left corner of the page, choose Database > 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.

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.

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.