Top Sessions lists all users connected to the MySQL database in logical I/O request order. Clicking a column heading changes the sort order of the table.
To open the Top Sessions page
Click Top Sessions.
Actions on the Top Sessions grid
Column | Description |
---|---|
Select (Highlight) a session |
View detailed information on the session. See: |
Kill a session |
Right-click the session and select Kill Session. A message appears with the serial number of the session to be killed. Click Yes to kill the session or click No to leave it running. Note: Not all users may have permission to kill sessions. This permission is granted by the Database Administrator. |
End a MySQL query |
Right-click the session and select Kill Query. A confirmation message appears. Click Yes to kill the query or click No to leave the query running. Note: Not all users may have permission to kill sessions. This permission is granted by the Database Administrator. |
The Top Sessions Grid
Notes:
Column | Description |
---|---|
ID |
The unique identifier for the user session. |
Host |
The name of the host from which the user has established a connection. |
User |
The MySQL account under which the user has connected to the database. |
Database |
The name of the MySQL database to which the user is currently connected. |
State |
The current state of the session. If the session is idle, this will be sleeping. Otherwise, the State column shows the current activity undertaken by the user. |
Time |
The amount of time – in seconds – for which the current query has been running. |
Command |
The type of command currently running for the session. |
Info |
More information; usually the text of the SQL statement being executed. |
Transaction State |
The current state of the transaction (for example, NOT STARTED or ACTIVE). Obtained from the output of the MySQL SHOW INNODB STATUS command. |
Queue State |
Obtained from the output of the MySQL SHOW INNODB STATUS command. |
Lock Heap Size |
Obtained from the output of the MySQL SHOW INNODB STATUS command. |
No. Lock Structs. |
Obtained from the output of the MySQL SHOW INNODB STATUS command. |
No. Tables in Use |
Obtained from the output of the MySQL SHOW INNODB STATUS command. |
No. Tables Locked |
Obtained from the output of the MySQL SHOW INNODB STATUS command. |
Undo Log Entries |
Obtained from the output of the MySQL SHOW INNODB STATUS command. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center