ALTER SYSTEM SET PARAMETER

更新时间：2026-04-04 19:36:16

描述

该语句用来修改本租户的配置项信息。

语法

ALTER SYSTEM SET parameter_name = expression;

参数解释

参数	描述
parameter_name	指定要修改的配置项名称。
expression	指定修改后的配置项的值。

示例

修改配置项 log_disk_utilization_threshold 的信息。

obclient> SHOW PARAMETERS LIKE 'log_disk_utilization_threshold';

预期返回结果：

+-------+----------+----------------+----------+--------------------------------+-----------+-------+--------------------------------------------------------------------------------------------------------------------------------------+------------+--------+---------+-------------------+
| zone  | svr_type | svr_ip        | svr_port | name                          | data_type | value | info                                                                                                                                     | section    | scope  | source  | edit_level        |
+-------+----------+----------------+----------+--------------------------------+-----------+-------+--------------------------------------------------------------------------------------------------------------------------------------+------------+--------+---------+-------------------+
| zone1 | observer | xx.xx.xx.xx   | 2882     | log_disk_utilization_threshold| NULL      | 80    | log disk utilization threshold before reuse log files, should be smaller than log_disk_utilization_limit_threshold. Range: [10, 100)    | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE |
+-------+----------+----------------+----------+--------------------------------+-----------+-------+--------------------------------------------------------------------------------------------------------------------------------------+------------+--------+---------+-------------------+
1 row in set

obclient> ALTER SYSTEM SET log_disk_utilization_threshold = 20;

obclient> SHOW PARAMETERS LIKE 'log_disk_utilization_threshold';

预期返回结果：


+-------+----------+----------------+----------+--------------------------------+-----------+-------+--------------------------------------------------------------------------------------------------------------------------------------+------------+--------+---------+-------------------+
| zone  | svr_type | svr_ip         | svr_port | name                           | data_type | value | info                                                                                                                                 | section    | scope  | source  | edit_level        |
+-------+----------+----------------+----------+--------------------------------+-----------+-------+--------------------------------------------------------------------------------------------------------------------------------------+------------+--------+---------+-------------------+
| zone1 | observer | xx.xx.xx.xx    |     2882 | log_disk_utilization_threshold | NULL      | 20    | log disk utilization threshold before reuse log files, should be smaller than log_disk_utilization_limit_threshold. Range: [10, 100) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE |
+-------+----------+----------------+----------+--------------------------------+-----------+-------+--------------------------------------------------------------------------------------------------------------------------------------+------------+--------+---------+-------------------+
1 row in set