Help Center > > User Guide> Distributed DDM DB Instance Management (Development Tool)> Intelligent O&M> Real-Time Sessions

Real-Time Sessions

Updated at: Jun 09, 2021 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.

Procedure

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

    Figure 1 Real-Time Sessions
    • In the upper left area, the graph 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 sessions.

      Select abnormal sessions and click Kill to kill them so that the database can recover.

    • Query specified sessions by filters.

      Search for sessions by user, host, or database. The two search boxes are associated.

    • Set slow SQL threshold.

      Set a slow session threshold and click the refreshing button 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