Refresh ODP configurations

This topic describes how to refresh the configurations of an ODP.

Refresh ODP configurations by using an SQL statement

You can refresh the configurations of a single ODP by executing the ALTER PROXYCONFIG statement.

1. Use the root@proxysys account to connect to the ODP.

2. Execute the following statement to view the value of the parameter to be refreshed.

   Sample code:

   obclient> SHOW PROXYCONFIG LIKE 'fetch_proxy_bin_random_time';
   

   You can also execute the SHOW PROXYCONFIG statement to view all parameters of the ODP.

3. Execute the following statement to modify the parameter value:

   obclient> ALTER PROXYCONFIG SET fetch_proxy_bin_random_time='300s';