SET AGGREGATOR
On this page
Sets a sync variable to propagate to all aggregators in the cluster.
Syntax
SET AGGREGATOR variable_name = valueArguments
-
variable_: name of the sync variable.name -
value: value to be assigned to the sync variable.
Remarks
-
variable_must be a variable type that can sync to all aggregators or a variable that can sync to all nodes (aggregators and leaves).name -
You cannot run this command on a non-sync variable.
-
This command must be run on the master aggregator.
Examples
Example 1
The following example syncs the variable auto_ to all aggregators.SET AGGREGATOR can be run on auto_ because auto_ is a variable that can sync to all aggregators.Description
column for the variable.
SET AGGREGATOR auto_attach = 1;
Retrieve the variable’s value:
SELECT @@auto_attach;
+---------------+
| @@auto_attach |
+---------------+
| 1 |
+---------------+Example 2
The following example syncs the variable regexp_ to all aggregators.SET AGGREGATOR can be run using regexp_ because regexp_ is a variable that can sync to all nodes (leaves and aggregators).Description
column for the variable.
SET AGGREGATOR regexp_format = "extended";
Retrieve the variable’s value:
SELECT @@regexp_format;
+-----------------+
| @@regexp_format |
+-----------------+
| extended |
+-----------------+Related Topics
-
See the Engine Variables Overview for information about other ways to set variables.
Last modified: June 22, 2022