SingleStore Managed Service

mv_nodes

The mv_nodes view in the information_schema database describes all SingleStore DB nodes in the cluster. It holds one row per node.

mv_nodes may only be queried while connected to an aggregator node.

Column name

Description

id

The ID of the node. This ID matches the node_id reported for tasks running on the node.

ip_addr

The IP address of the node.

port

The port on which the node is listening.

type

The type of a given node: MA, Leaf, or CA.

state

The state of a given node: Online, Offline, Detached, or Attaching.

availability_group

The ID of the related availability group for a given node.

num_cpus

The number of CPUs available to a given node.

max_memory_mb

The maximum memory use, in MB, of a given node. This is the same value as the engine variable maximum_memory.

max_table_memory_mb

The maximum memory, in MB, that can be used for table storage. This is the value value as the engine variable maximum_table_memory.

memory_used_mb

The amount of memory, in MB, used on a given node for storing tables, query execution, and any other purposes.

table_memory_used_mb

The amount of memory, in MB, used on a given node to store table data.

total_disk_data_mb

The total amount of disk storage, in MB.

available_disk_data_mb

The amount of available disk storage, in MB.

uptime

The amount of time in seconds that a node has been running.

version

The version of SingleStore that a given node is running on.