MV_GLOBAL_VARIABLES

This view contains information about the global variables that are set on the workspace’s nodes.

Global variables which are server status variables are not included and are found in the mv_global_status view.

Column name	Description
`node_id`	The ID of the node.
`ip_addr`	The IP address of the node.
`port`	The port on which the node is listening.
`node_type`	The type of node: master aggregator (MA), child aggregator (CA), or leaf node (LEAF).
`variable_name`	The name of the global variable.
`variable_value`	The value of the global variable.
`is_per_site`	Indicates whether the global variable can have independent values set for each cloud workspace.
`is_settable_at_startup`	Indicates whether the global variable can be set at cluster start up.
`is_settable_at_runtime`	Indicates whether the global variable can be set while the cluster is up.

Was this article helpful?