mysql.transaction_registry Table

The mysql.transaction_registry table was introduced in MariaDB 10.3.4 as part of system-versioned tables. It is used for transaction-precise versioning, and contains the following fields:

FieldTypeNullKeyDefaultDescription
transaction_idbigint(20) unsignedNOPrimaryNULL
commit_idbigint(20) unsignedNOUniqueNULL
begin_timestamptimestamp(6)NOMultiple0000-00-00 00:00:00.000000Timestamp when the transaction began (BEGIN statement), however see MDEV-16024.
committimestamp(6)NOMultiple0000-00-00 00:00:00.000000Timestamp when the transaction was committed.
isolation_levelenum('READ-UNCOMMITTED','READ-COMMITTED','REPEATABLE-READ','SERIALIZABLE')NONULLTransaction isolation level.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.