W3cubDocs

/MariaDB

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.

© 2019 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/