8.1.4 The rpd_mirror Table

The rpd_mirror table keeps track of all existing tables in the DB System, whose engine is InnoDB.

The rpd_mirror table has these columns:

SCHEMA_NAME
The schema name.
TABLE_NAME
The table name.
MYSQL_ACCESS_COUNT
Number of times the table has been accessed by the DB System.
HEATWAVE_ACCESS_COUNT
Number of times the table has been accessed by the MySQL HeatWave Cluster.
IMPORTANCE
Indicates the importance of each table for automatic load (also known as self load). Tables with higher importance values are loaded to MySQL HeatWave first. For a given table, this value is computed based on its size, as well as the number and duration of queries accessing that table.
LAST_QUERIED
The timestamp of the last DB System query that referenced the table.
LAST_QUERIED_IN_HEATWAVE
The timestamp of the last MySQL HeatWave query that referenced the table.
STATE
The table state: loaded or not loaded.
RECOMMENDED_READ_THREADS
Value of the innodb_parallel_read_threads session variable with which the table was previously loaded.
QUERIED_PARTITIONS
For partitioned tables, lists the InnoDB partitions that have been queried.