8.1.10 The rpd_tables Table

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.5.0, the possible values are SNAPSHOT, TRANSACTIONAL, and VOLATILE.

  • As of MySQL 9.2.1, the possible values are SNAPSHOT and TRANSACTIONAL.

  • In previous versions of MySQL, the possible values are RAPID_LOAD_POOL_SNAPSHOT and RAPID_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”

    Note

    When 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., in RPDGSTABSTATE) 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 using SECONDARY_UNLOAD followed by SECONDARY_LOAD. When a MySQL HeatWave cluster restarts, there is no attempt to recover tables in RECOVERYFAILED_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, or ObjectStorage.

• 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 in InnoDB.

  • 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.