mysql.transaction_registry Table
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:
| 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. |
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.
© 2021 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/