7.1.4 Change Propagation Monitoring

• To determine if change propagation is enabled globally, query the rapid_change_propagation_status variable:

  mysql> SELECT VARIABLE_VALUE FROM performance_schema.global_status
            WHERE VARIABLE_NAME = 'rapid_change_propagation_status';
  +----------------+
  | VARIABLE_VALUE |
  +----------------+
  | ON             |
  +----------------+

• To determine if change propagation is enabled for a particular table, query the POOL_TYPE data from the HeatWave Performance Schema tables. RAPID_LOAD_POOL_TRANSACTIONAL indicates that change propagation is enabled for the table. RAPID_LOAD_POOL_SNAPSHOT indicates that change propagation is disabled.

  mysql> USE performance_schema;
  mysql> SELECT NAME, POOL_TYPE FROM rpd_tables,rpd_table_id 
            WHERE rpd_tables.ID = rpd_table_id.ID AND SCHEMA_NAME LIKE 'tpch';
  +---------------+-------------------------------+
  | NAME          | POOL_TYPE                     |
  +---------------+-------------------------------+
  | tpch.orders   | RAPID_LOAD_POOL_TRANSACTIONAL |
  | tpch.region   | RAPID_LOAD_POOL_TRANSACTIONAL |
  | tpch.lineitem | RAPID_LOAD_POOL_TRANSACTIONAL |
  | tpch.supplier | RAPID_LOAD_POOL_TRANSACTIONAL |
  | tpch.partsupp | RAPID_LOAD_POOL_TRANSACTIONAL |
  | tpch.part     | RAPID_LOAD_POOL_TRANSACTIONAL |
  | tpch.customer | RAPID_LOAD_POOL_TRANSACTIONAL |
  +---------------+-------------------------------+