# 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](https://mariadb.com/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables). It is used for [transaction-precise versioning](https://mariadb.com/docs/server/sql-structure/temporal-tables/system-versioned-tables#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](https://mariadb.com/docs/server/sql-statements/administrative-sql-statements/set-commands/set-transaction#isolation-levels). |

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

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