On this page 
Warning:
CockroachDB v1.0 is no longer supported as of November 10, 2018. For more details, refer to the Release Support Policy.
The SET CLUSTER SETTING statement modifies a cluster-wide setting.
Warning:
Many cluster settings are intended for tuning CockroachDB internals. Before changing these settings, we strongly encourage you to discuss your goals with CockroachDB; otherwise, you use them at your own risk.Synopsis
Note:
The SET CLUSTER SETTING statement is unrelated to the other SET TRANSACTION and SET (session variable) statements.Required Privileges
Only the root user can modify cluster settings.
Parameters
| Parameter | Description |
|---|---|
var_name |
See the description of cluster settings. |
The variable name is case-insensitive.
Examples
Change the Default Distributed Execution Parameter
You can configure a cluster so that new sessions automatically try to run queries in a distributed fashion:
> SET CLUSTER SETTING sql.defaults.distsql = 1;
You can also disable distributed execution for all new sessions:
> SET CLUSTER SETTING sql.defaults.distsql = 0;
Disable Automatic Diagnostic Reporting
You can opt out of automatic diagnostic reporting of usage data to Cockroach Labs using the following:
> SET CLUSTER SETTING diagnostics.reporting.enabled = false;
> SHOW CLUSTER SETTING diagnostics.reporting.enabled;
+-------------------------------+
| diagnostics.reporting.enabled |
+-------------------------------+
| false |
+-------------------------------+
(1 row)
See Also
Was this helpful?
