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:
| 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. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/mysqltransaction_registry-table/