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