4.2 Status Variables

Several status variables provide operational information about HeatWave. You can retrieve status data using SHOW STATUS syntax. For example:

mysql> SHOW STATUS LIKE 'rapid%';
+---------------------------------+------------+
| Variable_name                   | Value      |
+---------------------------------+------------+
| hw_data_scanned                 | 0          |
| rapid_change_propagation_status | ON         |
| rapid_cluster_status            | ON         |
| rapid_core_count                | 64         |
| rapid_heap_usage                | 58720397   |
| rapid_load_progress             | 100.000000 |
| rapid_ml_status                 | ON         |
| rapid_plugin_bootstrapped       | YES        |
| rapid_preload_stats_status      | Available  |
| rapid_query_offload_count       | 46         |
| rapid_service_status            | ONLINE     |
+---------------------------------+------------+
  • hw_data_scanned

    Tracks the amount of data scanned by successfully executed HeatWave queries. Data is tracked in megabytes and is a cumulative total of data scanned since the HeatWave Cluster was last started. The counter is reset to 0 when the HeatWave Cluster is restarted (when the rapid_bootstrap state changes from OFF or IDLE to ON.)

  • rapid_change_propagation_status

    The change propagation status.

    A status of ON indicates that change propagation is enabled globally, permitting changes to InnoDB tables on the MySQL DB System to be propagated to their counterpart tables in the HeatWave Cluster.

  • rapid_cluster_status

    The HeatWave Cluster status.

  • rapid_core_count

    The HeatWave node core count. The value remains at 0 until all HeatWave nodes are started.

  • rapid_heap_usage

    MySQL DB System node heap usage.

  • rapid_load_progress

    A percentage value indicating the status of a table load operation.

  • rapid_ml_status

    The status of HeatWave ML. Possible values are ON and OFF.

  • rapid_plugin_bootstrapped

    The bootstrap mode.

  • rapid_preload_stats_status

    Reports the state of preload statistics collection. Column-level statistics are collected for tables on the MySQL DB System during a cluster size estimate. You can perform a cluster estimate when adding or editing a HeatWave Cluster. States include Not started, In progress, and Statistics collected.

    Preload statistics are cached in the rpd_preload_stats Performance Schema table. See Section 5.4.5, “The rpd_preload_stats Table”.

  • rapid_query_offload_count

    The number of queries offloaded to HeatWave for processing.

  • rapid_service_status

    Reports the status of the cluster as it is brought back online after a node failure.

  • Secondary_engine_execution_count

    The number of queries executed by HeatWave. Execution occurs if query processing using the secondary engine advances past the preparation and optimization stages. The variable is incremented regardless of whether query execution is successful.