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 parameter to be modified. |
| expression | Specifies the value of the configuration item after modification. |
Examples
Modify clog_max_unconfirmed_log_count.
obclient> SHOW PARAMETERS LIKE 'clog_max_unconfirmed_log_count';
+-------+----------+----------------+----------+--------------------------------+-----------+-------+-----------------------------------------------------------------+---------+--------+---------+-------------------+
ZONE SVR_TYPE SVR_IP SVR_PORT NAME DATA_TYPE VALUE INFO SECTION SCOPE SOURCE EDIT_LEVEL
+-------+----------+----------------+----------+--------------------------------+-----------+-------+-----------------------------------------------------------------+---------+--------+---------+-------------------+
zone1 observer 172.30.135.217 2882 clog_max_unconfirmed_log_count NULL 1500 maximum of unconfirmed logs in clog module. Range: [100, 50000] TRANS TENANT DEFAULT DYNAMIC_EFFECTIVE
+-------+----------+----------------+----------+--------------------------------+-----------+-------+-----------------------------------------------------------------+---------+--------+---------+-------------------+
1 row in set
obclient> ALTER SYSTEM SET clog_max_unconfirmed_log_count = 2000;
Query OK, 0 rows affected
obclient> SHOW PARAMETERS LIKE 'clog_max_unconfirmed_log_count';
+-------+----------+----------------+----------+--------------------------------+-----------+-------+-----------------------------------------------------------------+---------+--------+---------+-------------------+
ZONE SVR_TYPE SVR_IP SVR_PORT NAME DATA_TYPE VALUE INFO SECTION SCOPE SOURCE EDIT_LEVEL
+-------+----------+----------------+----------+--------------------------------+-----------+-------+-----------------------------------------------------------------+---------+--------+---------+-------------------+
zone1 observer 172.30.135.217 2882 clog_max_unconfirmed_log_count NULL 2000 maximum of unconfirmed logs in clog module. Range: [100, 50000] TRANS TENANT DEFAULT DYNAMIC_EFFECTIVE
+-------+----------+----------------+----------+--------------------------------+-----------+-------+-----------------------------------------------------------------+---------+--------+---------+-------------------+
1 row in set