Purpose
You can use this statement to modify the parameters of the current tenant.
Syntax
ALTER SYSTEM SET parameter_name = expression;
Parameters
| Parameter | Description |
|---|---|
| parameter_name | The name of the configuration item to be modified. |
| expression | The value of the configuration item after modification. |
Examples
Modify the log_disk_utilization_threshold parameter.
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;
Query OK, 0 rows affected
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