Related Documentation Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb

HeatWave User Guide  /  Reference  /  Status Variables

11.9 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_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_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 when generating a node count estimate. You can generate a node count estimate when adding or modifying a HeatWave cluster. States include Not started, In progress, and Statistics collected.

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