7.3.5 The rpd_nodes Table

The rpd_nodes table provides information about HeatWave nodes.

The rpd_nodes table has these columns:

• ID

  A unique identifier for the HeatWave node.

• CORES

  The number of cores used by the HeatWave node.

• MEMORY_USAGE

  Node memory usage in bytes. The value is refreshed every four seconds. If a query starts and finishes in the four seconds between refreshes, the memory used by the query is not accounted for in the reported value.

• MEMORY_TOTAL

  The total memory in bytes allocated to the HeatWave node.

• BASEREL_MEMORY_USAGE

  The base relation memory footprint per node.

• STATUS

  The status of the HeatWave node. Possible statuses include:

  • NOTAVAIL_RNSTATE

    Not available.

  • AVAIL_RNSTATE

    Available.

  • DOWN_RNSTATE

    Down.

  • SPARE_RNSTATE

    Spare.

  • DEAD_RNSTATE

    The node is not operational.

• IP

  IP address of the HeatWave node.

• PORT

  The port on which the HeatWave node was started.

• CLUSTER_EVENT_NUM

  The number of cluster events such as node down, node up, and so on.

• NUM_OBJSTORE_GETS

  Number of GET requests from the node to the object store.

• NUM_OBJSTORE_PUTS

  The number of PUT requests from the node to the object store.

• NUM_OBJSTORE_DELETES

  The number of DELETE requests from the node to the object store.

• ML_STATUS

  HeatWave AutoML status. Possible status values include:

  • UNAVAIL_MLSTATE: HeatWave AutoML is not available.

  • AVAIL_MLSTATE: HeatWave AutoML is available.

  • DOWN_MLSTATE: HeatWave AutoML declares the node is down.

The rpd_nodes table is read-only.

The rpd_nodes table may not show the current status for a new node or newly configured node immediately. The rpd_nodes table is updated after the node has successfully joined the cluster.

If additional nodes fail while node recovery is in progress, the newly failed nodes are not detected and their status is not updated in the performance_schema.rpd_nodes table until after the current recovery operation finishes and the nodes that failed previously have rejoined the cluster.