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:

ColumnDescription
READ_VIEW_UNDO_NUMBER
READ_VIEW_LOW_LIMIT_TRX_NUMBERHighest transaction number at the time the view was created.
READ_VIEW_UPPER_LIMIT_TRX_IDHighest 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_IDLatest committed transaction ID at the time the oldest view was created. Should see all transactions with IDs equal to or less than the value.

Comments

Comments loading...
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.