> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-transaction_registry-table.md).

# mysql.transaction\_registry Table

1. PARTITION BY SYSTEM\_TIME is not supported for transaction-precise system-versioned tables. Attempting

The `mysql.transaction_registry` table is part of [system-versioned tables](/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables.md). It is used for [transaction-precise versioning](/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables.md#transaction-precise-history-in-innodb), 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](https://jira.mariadb.org/browse/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](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-transaction.md#isolation-levels). |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}