6.1.4 The rpd_nodes Table

MySQL AI supports only one AI node. The rpd_nodes table provides information about the AI node.

The rpd_nodes table has these columns:

• ID

  A unique identifier for the MySQL AI Engine (AI engine).

• CORES

  The number of cores used by the AI engine.

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

• BASEREL_MEMORY_USAGE

  The base relation memory footprint per node.

• STATUS

  The status of the AI engine. Possible statuses include:

  • NOTAVAIL_RNSTATE

    Not available.

  • AVAIL_RNSTATE

    Available.

  • DOWN_RNSTATE

    Down.

  • DEAD_RNSTATE

    The node is not operational.

• IP

  IP address of the AI engine.

• PORT

  The port on which the AI engine 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 AI engine to the disk.

• NUM_OBJSTORE_PUTS

  The number of PUT requests from the AI engine to the disk.

• NUM_OBJSTORE_DELETES

  The number of DELETE requests from the AI engine to the disk.

• ML_STATUS

  AutoML status. Possible status values include:

  • UNAVAIL_MLSTATE: AutoML is not available.

  • AVAIL_MLSTATE: AutoML is available.

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