描述

    使用alter proxyconfig set key=value语句：

    • 更新proxy内部指定config配置项值，如果找不到指定config配置项，或者更新值为无效值，则返回响应错误码。
    • value支持单引号'value'或者双引号"value"。

    示例

    1. OceanBase (admin@oceanbase)> show proxyconfig like 'fetch_bin_min_random_time';
    2. +---------------------------+-------+--------------------------------------------------------------+-------------+
    3. | name                      | value | info                                                         | need_reboot |
    4. +---------------------------+-------+--------------------------------------------------------------+-------------+
    5. | fetch_bin_min_random_time | 3     | min random waiting time of fetching proxy bin in hot upgrade | false       |
    6. +---------------------------+-------+--------------------------------------------------------------+-------------+
    7. 1 row in set (0.01 sec)
    9. OceanBase (admin@oceanbase)> alter proxyconfig set fetch_bin_min_random_time=12m;
    10. Query OK, 0 rows affected (0.00 sec)
    12. OceanBase (admin@oceanbase)> show proxyconfig like 'fetch_bin_min_random_time';
    13. +---------------------------+-------+--------------------------------------------------------------+-------------+
    14. | name                      | value | info                                                         | need_reboot |
    15. +---------------------------+-------+--------------------------------------------------------------+-------------+
    16. | fetch_bin_min_random_time | 12m   | min random waiting time of fetching proxy bin in hot upgrade | false       |
    17. +---------------------------+-------+--------------------------------------------------------------+-------------+
    18. 1 row in set (0.00 sec)
    20. OceanBase (admin@oceanbase)> alter proxyconfig set fetch_bin_min_random_time="12s";
    21. Query OK, 0 rows affected (0.00 sec)
    23. OceanBase (admin@oceanbase)> show proxyconfig like 'fetch_bin_min_random_time';
    24. +---------------------------+-------+--------------------------------------------------------------+-------------+
    25. | name                      | value | info                                                         | need_reboot |
    26. +---------------------------+-------+--------------------------------------------------------------+-------------+
    27. | fetch_bin_min_random_time | 12s   | min random waiting time of fetching proxy bin in hot upgrade | false       |
    28. +---------------------------+-------+--------------------------------------------------------------+-------------+
    29. 1 row in set (0.00 sec)