説明
このステートメントは、現在のテナントのパラメータ情報を変更するために使用されます。
構文
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