The rpd_tables
table provides the system
change number (SCN) and load pool type for tables loaded in
MySQL HeatWave.
The rpd_tables
table is read-only.
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.
As of MySQL 9.2.1, the possible values are
SNAPSHOT
andTRANSACTIONAL
.In previous versions of MySQL, the possible values are
RAPID_LOAD_POOL_SNAPSHOT
andRAPID_LOAD_POOL_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. See Section 4.2.7, “About Change Propagation”
NoteWhen
TRUNCATE TABLE
operation is performed, the table is marked for a full reload. However, the table is not reloaded immediately. The system reloads the table only after all currently undergoing incremental or scheduled reloads. hence, the table may appear as stale in the system (e.g., inRPDGSTABSTATE
) until it is reloaded completely. -
UNAVAIL_RPDGSTABSTATE
The table is unavailable.
-
RECOVERYFAILED_RPDGSTABSTATE
This status is available as of MySQL 9.2.2. A Lakehouse table is marked as
RECOVERYFAILED_RPDGSTABSTATE
when an attempt to recover it fails. Tables in this state can be unloaded. Therefore, before using tables in this state, you need to manually reload them usingSECONDARY_UNLOAD
followed bySECONDARY_LOAD
. When a MySQL HeatWave cluster restarts, there is no attempt to recover tables inRECOVERYFAILED_RPDGSTABSTATE
. However, when a DB System restarts, an attempt is made to recover tables in this state.
-
-
LOAD_PROGRESS
The load progress of the table expressed as a percentage value.
For Lakehouse, the following values are returned:
10%: the initialization phase is complete.
10-70%: the transformation to native MySQL HeatWave format is in progress.
70% - 80%: the transformation to native MySQL HeatWave format is complete and the aggregation phase is in progress.
80-99%: the recovery phase is in progress.
100%: data load is complete.
-
SIZE_BYTES
The amount of data loaded for the table, in bytes.
-
TRANSFORMATION_BYTES
:The total size of raw Lakehouse data transformed, in bytes.
-
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. The values are
MySQL
, that is InnoDB, orObjectStorage
. -
RECOVERY_START_TIMESTAMP
The timestamp when the latest successful recovery started.
-
RECOVERY_END_TIMESTAMP
The timestamp when the latest successful recovery ended.
-
LOAD_TYPE
Specifies whether the table is automatically loaded by MySQL HeatWave (
SELF
) or loaded by the user (USER
). -
LOGICAL_PARTS_LOADED_AT_SCN
For partitioned tables, contains an array of JSON objects, each corresponding to a loaded partition. For each partition, the following values are stored:
id
: the id of the partition inInnoDB
.name
: the name of the partition.load_scn
: the system change number (SCN) at which the partition was loaded.load_type
: specifies whether the table is automatically loaded by MySQL HeatWave, or loaded by the user.
-
AUTO_ZMP_COLUMNS
Contains a list of IDs that correspond to the columns on which zone maps are automatically built.
-
ACE_MODEL
Available as of MySQL 9.3.0, indicates whether an Advanced Cardinality Estimation (ACE) statistics model is currently associated with the given table in MySQL HeatWave.