MariaDB starting with 10.3.4

The mysql.transaction_registry table was introduced in MariaDB 10.3.4 as part of system-versioned tables.

The mysql.transaction_registry table 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...