mysql_innodb_trx
List open InnoDB transactions with their age, thread, and query to detect long-running locks and transaction history issues.
Instructions
Open InnoDB transactions (age, thread, query). Long trx_age_sec pins locks/history.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||