MV_ TRANSACTION_ TABLE
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
Contains distributed transaction metadata.
Column Name |
Description |
---|---|
|
The node the transaction is from (MV). |
|
The name of the database including the partition ordinal. |
|
The state of the database (i. |
|
The ID of the sharded database. |
|
The role of the database: Primary or Replica |
|
The ID of the distributed transaction. |
|
The ID of the coordinator. |
|
The timestamp the transaction selects just before beginning its prepare phase. |
|
Timestamp of the commit. |
|
List of all participants of the distributed transaction. |
|
State of the transaction: Prepared, Committed, or Aborted |
Last modified: June 5, 2023