5.4.4 rpd_nodes 表

该rpd_nodes表提供了有关 HeatWave 节点的信息。

该rpd_nodes表有以下列：

  • ID

    HeatWave 节点的唯一标识符。

  • CORES

    HeatWave 节点使用的核心数。

  • MEMORY_USAGE

    节点内存使用量（以字节为单位）。该值每四秒刷新一次。如果查询在刷新之间的四秒内开始和完成，则查询使用的内存不计入报告值。

  • MEMORY_TOTAL（从 DRAMMySQL 8.0.24 中重命名）

    分配给 HeatWave 节点的总内存（以字节为单位）。

  • BASEREL_MEMORY_USAGE

    每个节点的基本关系内存占用。

  • STATUS

    HeatWave 节点的状态。可能的状态包括：

    • NOTAVAIL_RNSTATE

      无法使用。

    • AVAIL_RNSTATE

      可用的。

    • DOWN_RNSTATE

      下。

    • SPARE_RNSTATE

      空闲的。

    • DEAD_RNSTATE

      该节点不可操作。

  • IP

    HeatWave 节点的 IP 地址。

  • PORT

    启动 HeatWave 节点的端口。

  • CLUSTER_EVENT_NUM

    集群事件的数量，例如节点关闭、节点启动等。

  • NUM_OBJSTORE_GETS

    GET从节点到对象存储 的请求数。

  • 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 Machine Learning status. Possible status values include:

    • UNAVAIL_MLSTATE: HeatWave Machine Learning is not available.

    • AVAIL_MLSTATE: HeatWave Machine Learning is available.

    • DOWN_MLSTATE: HeatWave Machine Learning 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.