Help Center > > User Guide> DDM DB Instance Management (Standard Edition)> CloudDBA> Real-Time Sessions

Real-Time Sessions

Updated at: Sep 29, 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 a DDM DB instance on the DAS console.
  • You have obtained the process permission.

Procedure

  1. On the top menu bar, choose CloudDBA > Real-Time Sessions.
  2. On the displayed page, view the running sessions, session execution duration, session list, and slow sessions.

    • In the upper left area, the chart shows the number of global sessions, which keeps the same as the search criteria change.
    • In the upper right area, the graph shows the query results based on your search criteria.

    • Kill a session.

      Select an abnormal session and click Kill to kill it so that the database can recover.

    • Query specified sessions by filters.

      Search for sessions by user, host, or database.

    • Set slow SQL threshold.

      Set a slow session threshold and click Refresh to filter the slow sessions that exceed this threshold.

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