4.8.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 MySQL HeatWave Performance Schema tables.

  • As of MySQL 9.2.1, TRANSACTIONAL indicates that change propagation is enabled for the table. SNAPSHOT indicates that change propagation is disabled.

  • In previous versions of MySQL, 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   | TRANSACTIONAL |
  | tpch.region   | TRANSACTIONAL |
  | tpch.lineitem | TRANSACTIONAL |
  | tpch.supplier | TRANSACTIONAL |
  | tpch.partsupp | TRANSACTIONAL |
  | tpch.part     | TRANSACTIONAL |
  | tpch.customer | TRANSACTIONAL |
  +---------------+---------------+