mysql.transaction_registry Table

The mysql.transaction_registry table is used by system-versioned tables to track transaction IDs and their commit timestamps.

System tables should not normally be edited directly. Use the related SQL statements instead.

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

Field	Type	Null	Key	Default	Description
transaction_id	bigint(20) unsigned	NO	Primary	NULL
commit_id	bigint(20) unsigned	NO	Unique	NULL
begin_timestamp	timestamp(6)	NO	Multiple	0000-00-00 00:00:00.000000	Timestamp when the transaction began (BEGIN statement), however see MDEV-16024.
commit	timestamp(6)	NO	Multiple	0000-00-00 00:00:00.000000	Timestamp when the transaction was committed.
isolation_level	enum('READ-UNCOMMITTED','READ-COMMITTED','REPEATABLE-READ','SERIALIZABLE')	NO		NULL	Transaction isolation level.

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