Transaction Page
The Transaction page of the Top Sessions drilldown displays the details of the current transaction for the selected session.
To open the Transaction page
- Select the Spotlight on MySQL connection in the Spotlight Browser.
-
Click Top Sessions Page.
- Select a row in the Top Sessions grid.
- Click Transaction.
Data on the Transaction page
Within the InnoDB storage engine, all user activity occurs inside a transaction.
| Control | Description |
|---|---|
|
MySQL Thread ID |
The Thread ID of the current MySQL connection. |
|
Query ID |
The ID of the query 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. |
|
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. |
|
Queue State |
Obtained from the output of the MySQL SHOW INNODB STATUS command. |
|
No. Locked Struct(s) |
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. |
|
Undo Log Entries |
Obtained from the output of the MySQL SHOW INNODB STATUS command. |