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.