10.10.2 The rpd_nodes Table

Therpd_nodestable provides information about HeatWave nodes.

Therpd_nodestable has these columns:

  • ID

    A unique identifier for the HeatWave node.

  • CORES

    The number of cores used by the HeatWave node.

  • MEMORY_TOTAL(renamed fromDRAMin MySQL 8.0.24)

    The total memory in bytes allocated to the HeatWave 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的一个ddress of the HeatWave node.

  • PORT

    The port on which the HeatWave node was started.

  • 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. Introduced in MySQL 8.0.24.

Therpd_nodestable is read-only. DDL, includingTRUNCATE TABLE, is not permitted.

Therpd_nodestable may not show the current status for a new node or newly configured node immediately. Therpd_nodestable 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 theperformance_schema.rpd_nodestable until after the current recovery operation finishes and the nodes that failed previously have rejoined the cluster.