Sessions

Usage Notes

Killing a session may cause instance or service exceptions.

Procedure

1. Log in to the DAS console.
2. Click in the upper left corner and select a region and project.
3. In the navigation pane, choose Intelligent O&M > Instance List.

   Alternatively, on the Overview page, click Go to Intelligent O&M.

4. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.
5. Locate the target instance and click Details. The Dashboard page is displayed.
6. On the Sessions tab page, perform the following operations:
   • View session statistics.

     In the session statistics area, you can view statistics on slow sessions, active sessions, total sessions, and long transaction sessions by user, access host, and database.

     Figure 1 Sessions
     
   • Set a slow session threshold.
     Click Set Slow Session Threshold. In the displayed dialog box, set Max. Execution Time for a Query (s) and click OK. Sessions whose execution time exceeds the threshold are automatically displayed in the session list.

     Figure 2 Setting a slow session threshold
     
   • Manage sessions.
     Figure 3 Session list
     
     • Kill sessions.

       In the session list, you can view session details. You can also select the abnormal sessions you want to terminate based on session status and workload requirements and click Kill Session to recover the database. To terminate multiple sessions, select up to 20 sessions and click Kill Session above the list.

     • Perform session analysis.

       Choose Session Analysis > Collect to collect the real-time session information first. After the collection is complete, choose Session Analysis > Session Analysis Result to view the analysis result.

     • Export session data.
       • Exporting data of selected sessions

         Select required session records and click Export Selected above the list to export the session details. After the export is complete, a CSV file is generated on the local PC.

       • Exporting all sessions

         Choose Export All > Collect above the list to collect real-time information about all sessions. After the collection is complete, choose Export All > Download to export the session details. After the export is complete, a CSV file is generated on the local PC.

         A maximum of 1,000,000 sessions can be exported at a time.

   • Check the transaction rollback progress.
     Figure 4 Checking the transaction rollback progress
     

     Click the Transaction Rollback Progress tab to view the transaction ID, session ID, transaction status, number of processed rows, and execution statements.

   • View the killing history of top 3 session groups.
     Figure 5 Viewing the killing history of top 3 session groups
     

     Click the Killed Top 3 tab to view the history of Kill Top 3 operations. You can also download the instance-level operation history of the last three days.