The Transaction page of the Top Sessions drilldown displays the details of the current transaction for the selected session.
To open the Transaction page
Click Top Sessions Page.
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. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center