MySQL AI  /  ...  /  The rpd_nodes Table

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.