|
Returns a list of transactions that are currently active.
sa_transactions( )
| Column name | Data type | Description |
|---|---|---|
| connection_num | INT | The connection ID for the connection the transaction is running on. |
| transaction _id | INT | The ID that uniquely identifies the transaction as long as the database server keeps track of it. IDs are reused as old transaction information is discarded. |
| start_time | TIMESTAMP | The TIMESTAMP for when the transaction started. |
| start_sequence_num | UNSIGNED BIGINT | The start sequence number for the transaction. |
| end_sequence_num | UNSIGNED BIGINT | Then end sequence number for the transaction if it has been committed or rolled back, otherwise, NULL. |
| committed | bit | The state of the transaction: true if the transaction ended with a COMMIT, false if it ended with a ROLLBACK, and NULL if the transaction is still active. |
| version_entries | unsigned INT | The count of the number of row versions the transaction has saved. |
This procedure provides information about the transactions that are currently running against the database.
DBA authority required
None