Help Center > > User Guide> MySQL Database Management> DB Instance Management> Session

Session

Updated at: Mar 20, 2020 GMT+08:00

Scenarios

View the running duration and status of SQL statements online to detect and handle abnormal processes in a timely manner to ensure that databases run smoothly.

Prerequisites

You have logged in to the DAS console.

Procedure

  1. In the menu bar, choose Instance Management > Session.
  2. On the displayed page, view the current active sessions of the DB instance.

    • Kill a session.

      Locate the abnormal session and click Kill Session to restore the database.

    • Kill all sessions.

      Click Kill All Sessions to terminate all sessions.

    • Search for sessions by criteria.

      Enter search criteria, such as user, host, SQL statement, time, state, and command, and click Search.

    • Enable the auto refresh function.

      Enable Auto Refresh. The system automatically refreshes the page every 30s.

    • Display all sessions.

      Enable Display All. All sessions will be displayed. If you disable Display All, only the running sessions will be displayed.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel