MV_ NODES
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
This view describes all SingleStore nodes in the cluster.
The view holds one row per node.
mv_
may only be queried while connected to an aggregator node.
Column name |
Description |
---|---|
|
The ID of the node. |
|
The IP address of the node. |
|
The port on which the node is listening. |
|
The type of a given node: |
|
The state of a given node: |
|
The |
|
The number of CPUs available to a given node. |
|
The maximum memory use, in MB, of a given node. |
|
The maximum memory, in MB, that can be used for table storage. |
|
The amount of memory, in MB, used on a given node for storing tables, query execution, and any other purposes. |
|
The amount of memory, in MB, used on a given node to store table data. |
|
The total amount of disk storage, in MB. |
|
The amount of available disk storage, in MB. |
|
The amount of time in seconds that a node has been running. |
|
The version of SingleStore that a given node is running on. |
Last modified: August 29, 2022