tencent cloud

TDSQL Boundless

DocumentationTDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMATDSTORE_LARGE_TXN

TDSTORE_LARGE_TXN

Download
Focus Mode
Font Size
Last updated: 2026-05-26 15:36:48

Function

TDSTORE_LARGE_TXN is used to query the running status and resource usage of large transactions at the TDStore layer.

Field Description

Field Name
Type
Description
replication_group_id
bigint unsigned
The ID of the Replication Group to which the large transaction belongs.
transaction_id
bigint unsigned
The Transaction ID of the large transaction.
prepare_ts
bigint unsigned
The prepare timestamp of the large transaction.
commit_ts
bigint unsigned
The commit timestamp of the large transaction.
raft_log_index
bigint
The Raft Log Index when the large transaction is committed or rolled back.
main_cf_id
int
The primary Column Family ID corresponding to the large transaction.
compacted
int
Whether the data of the large transaction has been compacted.
rollback
int
Whether the large transaction has been rolled back.
destroyed
int
Whether the large transaction has been destroyed.
split_merge_rep_group_ids
varchar(513)
The list of Replication Group IDs from split/merge sources.
split_merge_raft_log_indexes
varchar(513)
The list of Raft Log Indexes from split/merge sources.
persisted_raft_log_index
bigint
The Raft Log Index that has been persisted for the large transaction. -1 indicates that all logs have been persisted.
disk_usage_bytes
bigint unsigned
The disk space occupied by the large transaction, in bytes.
memory_usage_bytes
bigint unsigned
The memory space occupied by the large transaction, in bytes.

Examples

During a transaction that is in progress (and not yet committed), large transaction records can be observed:
tdsql> SELECT * FROM information_schema.TDSTORE_LARGE_TXN\\G
*************************** 1. row ***************************
        replication_group_id: 769
              transaction_id: 29749682641045458
                  prepare_ts: NULL
                   commit_ts: NULL
              raft_log_index: NULL
                  main_cf_id: 2
                   compacted: 0
                    rollback: 0
                   destroyed: 0
 split_merge_rep_group_ids: []
split_merge_raft_log_indexes: []
    persisted_raft_log_index: 0
            disk_usage_bytes: 0
          memory_usage_bytes: 602104
1 row in set (0.00 sec)
After a transaction is committed:

tdsql> SELECT * FROM information_schema.TDSTORE_LARGE_TXN\\G
*************************** 1. row ***************************
        replication_group_id: 769
              transaction_id: 29749682641045458
                  prepare_ts: 29749682641045458
                   commit_ts: 29749682641045504
              raft_log_index: 84
                  main_cf_id: 2
                   compacted: 1
                    rollback: 0
                   destroyed: 0
 split_merge_rep_group_ids: []
split_merge_raft_log_indexes: []
    persisted_raft_log_index: -1
            disk_usage_bytes: 3577
          memory_usage_bytes: 2048
1 row in set (0.00 sec)
Previous Topic: TDSTORE_INSTALL_SNAPSHOT_INFONext Topic: TDSTORE_LOCAL_METADATA_DESTROY_REPLICA

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback