6.1.6 The rpd_tables Table

The rpd_tables table provides the system change number (SCN) and load pool type for tables loaded in the MySQL AI Engine (AI engine).

The rpd_tables table has these columns:

ID
A unique identifier for the table.
SNAPSHOT_SCN
The system change number (SCN) of the table snapshot. The SCN is an internal number that represents a point in time according to the system logical clock that the table snapshot was transactionally consistent with the source table.
PERSISTED_SCN
The SCN up to which changes are persisted.
POOL_TYPE
The load pool type of the table. Possible values are SNAPSHOT and TRANSACTIONAL.
DATA_PLACEMENT_TYPE
The data placement type.
NROWS
The number of rows that are loaded for the table. The value is set initially when the table is loaded, and updated as changes are propagated.
LOAD_STATUS
The load status of the table. Statuses include:
- NOLOAD_RPDGSTABSTATE
  The table is not yet loaded.
- LOADING_RPDGSTABSTATE
  The table is being loaded.
- AVAIL_RPDGSTABSTATE
  The table is loaded and available for queries.
- UNLOADING_RPDGSTABSTATE
  The table is being unloaded.
- INRECOVERY_RPDGSTABSTATE
  The table is being recovered. After completion of the recovery operation, the table is placed back in the UNAVAIL_RPDGSTABSTATE state if there are pending recoveries.
- STALE_RPDGSTABSTATE
  A failure during change propagation, and the table has become stale.
- UNAVAIL_RPDGSTABSTATE
  The table is unavailable.
LOAD_PROGRESS
The load progress of the table expressed as a percentage value.
SIZE_BYTES
The amount of data loaded for the table, in bytes.
NROWS:
The number of rows loaded to the external table.
QUERY_COUNT
The number of queries that referenced the table.
LAST_QUERIED
The timestamp of the last query that referenced the table.
LOAD_START_TIMESTAMP
The load start timestamp for the table.
LOAD_END_TIMESTAMP
The load completion timestamp for the table.
RECOVERY_SOURCE
Indicates the source of the last successful recovery for a table.
RECOVERY_START_TIMESTAMP
The timestamp when the latest successful recovery started.
RECOVERY_END_TIMESTAMP
The timestamp when the latest successful recovery ended.

The rpd_tables table is read-only.