HeatWave User Guide  /  ...  /  Change Propagation Monitoring

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.

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