# MV\_NODES

This view describes all SingleStore nodes in the cluster.

The view 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_data_disk_mb`     | The total amount of disk storage, in MB.                                                                                             |
| `available_data_disk_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.                                                                          |

***

Modified at: August 29, 2022

Source: [/db/v9.1/reference/information-schema-reference/management/mv-nodes/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-nodes/)

(An index of the documentation is available at /llms.txt)