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.