OceanBase Cloud Platform (OCP) allows you to view and modify parameters of an OceanBase Database Proxy (ODP) cluster on the Parameters and Change History tabs of the Parameter Management page.
View or modify parameters
Log in to the OCP console.
In the left-side navigation pane, click OBProxy.
In the ODP cluster list, click the target ODP cluster.
The Overview page of the ODP cluster appears.
Click Parameter Management in the left-side navigation pane.
The Parameters tab automatically appears.
You can perform the following operations on this tab:
View parameters
Enter a parameter name in the search box to search for specific parameters. Fuzzy search is supported.
Modify parameters
Find the target parameter, and click Change Value in the Actions column.
Specify Value and click OK.
After the values of all target parameters are modified, click Submit Changes.
In the panel that appears, confirm the modifications and click Confirm Modification.
The modification succeeds when the modification task is completed.
After you modify the parameters, check how the parameters take effect.
- For parameters that take effect without a restart, the parameter modifications take effect in about 3 minutes.
- For parameters that take effect after a restart, you must restart the OCP server for the modifications to take effect.
View change history
Log in to the OCP console.
In the left-side navigation pane, click OBProxy.
In the ODP cluster list, click the target ODP cluster.
The Overview page of the ODP cluster appears.
Click Parameter Management in the left-side navigation pane.
The Parameters tab automatically appears.
Click the Change History tab.
On the Change History tab, you can specify the Date of Modification and Parameter Name fields, and then click Search to filter parameters. In the parameter list, you can view the information in the following columns: Parameter, Value Before Change, Value After Change, Modified At, and Changed By.