MV_ ACTIVE_ DISTRIBUTED_ TRANSACTIONS
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.
This view shows internal information on distributed transactions that are currently active in the system.
Primarily for use by SingleStore Customer Support.
Column Name |
Description |
---|---|
|
The internal ID of the distributed transaction. |
|
ID of the aggregator coordinating the distributed transaction. |
|
Internal connection ID between the node and the aggregator. |
|
ID of the node where the transaction is running. |
|
The name of the database or partition running the transaction. |
|
The isolation level the distributed transaction is running on. |
|
Time of the start of the transaction. |
|
Internal timestamp of the start of the transaction. |
|
Internal timestamp of the first data read from the transaction. |
|
The state of the transaction: |
|
The internal timestamp of when the local prepare step of the transaction was executed. |
|
Number of rows locks held by the transaction. |
Last modified: July 30, 2024