RESET CLUSTER SETTING
The RESET
statement resets a cluster setting to its default value for the client session..
Required privileges
Only members of the admin
role can modify cluster settings. By default, the root
user belongs to the admin
role.
Synopsis
Parameters
Parameter | Description |
---|---|
var_name | The name of the cluster setting (case-insensitive). |
Example
Tip:
You can use SET CLUSTER SETTING .. TO DEFAULT
to reset a cluster setting as well.
> SET CLUSTER SETTING sql.metrics.statement_details.enabled = false;
> SHOW CLUSTER SETTING sql.metrics.statement_details.enabled;
+---------------------------------------+
| sql.metrics.statement_details.enabled |
+---------------------------------------+
| false |
+---------------------------------------+
(1 row)
> RESET CLUSTER SETTING sql.metrics.statement_details.enabled;
> SHOW CLUSTER SETTING sql.metrics.statement_details.enabled;
+---------------------------------------+
| sql.metrics.statement_details.enabled |
+---------------------------------------+
| true |
+---------------------------------------+
(1 row)
See also
当前内容版权归 cockroachlabs.com 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 cockroachlabs.com .