MV_GLOBAL_VARIABLES

This view contains information about the global variables that are set on the cluster’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.

Last modified: December 15, 2023

Was this article helpful?