Information Schema XTRADB_READ_VIEW Table
MariaDB starting with 10.0.9
The XTRADB_READ_VIEW table was added in MariaDB 10.0.9.
The Information Schema XTRADB_READ_VIEW table contains information about the oldest active transaction in the system.
The PROCESS privilege is required to view the table.
It has the following columns:
| Column | Description |
|---|---|
READ_VIEW_UNDO_NUMBER |
|
READ_VIEW_LOW_LIMIT_TRX_NUMBER |
Highest transaction number at the time the view was created. |
READ_VIEW_UPPER_LIMIT_TRX_ID |
Highest transaction ID at the time the view was created. Should not see newer transactions with IDs equal to or greater than the value. |
READ_VIEW_LOW_LIMIT_TRX_ID |
Latest committed transaction ID at the time the oldest view was created. Should see all transactions with IDs equal to or less than the value. |
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/information-schema-xtradb_read_view-table/