Information Schema ROCKSDB_TRX Table

The Information Schema ROCKSDB_TRX table provides information about active transactions in MyRocks, including transaction IDs and states.

The Information Schema ROCKSDB_TRX table is included as part of the MyRocks storage engine.

The PROCESS privilege is required to view the table.

It contains the following columns:

Column	Description
TRANSACTION_ID
STATE
NAME
WRITE_COUNT
LOCK_COUNT
TIMEOUT_SEC
WAITING_KEY
WAITING_COLUMN_FAMILY_ID
IS_REPLICATION
SKIP_TRX_API
READ_ONLY
HAS_DEADLOCK_DETECTION
NUM_ONGOING_BULKLOAD
THREAD_ID
QUERY

_{This page is licensed: CC BY-SA / Gnu FDL}