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.