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