Session Diagnosis
Last Updated:2021-11-09
Overview
View and analyze the real-time session information and quickly locate lock wait, slow SQL, or other performance problems in the instance. Analyze the session statistics from multiple perspectives such as user, database, status, and source, and quickly locate exceptional sessions.
Interpretation of Terms
Real-time session: shows the processlist session information in real time and allows you to view the current session but not to perform any operation. Session statistics: allows you to accomplish the statistics from four perspectives, including user, access source, database, and session status.
Operation Guide
- Log in to the Console of Baidu AI Cloud Database RDS.
- In the RDS console, select a MySQL dual-computer high-availability master instance, and click the instance name to enter the Instance Details.
- On the "Baidu AI Cloud Database RDS Instance Details" page, click SmartDBA to show the module information.
- Click Session Diagnosis and select "Real-time Session" or "Session Statistics" in the diagnosis type to view the relevant information.
Real-time Session
Session Statistics