Top Sessions Page
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
- Select the Spotlight on MySQL connection in the Spotlight Browser.
-
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:
- Not all columns are visible by default. Use the Column Organizer to view hidden columns. Show, Hide & Order Columns
- The values in this table are obtained from the output of the SHOW FULL PROCESSLIST or SHOW INNODB STATUS commands.
| 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. |