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 cluster.

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:

Was this article helpful?