This topic describes how to modify system parameters.
Background
System parameters in OceanBase Cloud Platform (OCP) control a series of complex configurations, such as backup and restore and the frequency of resource monitoring. We do not recommend that general users modify system parameters.
After you deploy OCP, it sets a default value for these parameters to satisfy day-to-day usage. If you have a particular need, you can ask an admin to modify the related system parameter for you.
Prerequisites
The logged-on user has the ADMIN or PROPERTY_MANAGER role in OceanBase Cloud Platform (OCP).
Procedure
Log on to the OCP console.
In the left-side navigation pane, choose System Management > System Parameters.
By default, the Parameters list displays all the modifiable parameters.
Enter a keyword in the search box in the upper-right corner of the Parameters list and click Search.
The system parameters whose names match the keyword are displayed in the Parameters list.
Click the Edit icon in the Parameter Value column of the target parameter.
The Modify Parameter Value dialog box appears.
Enter a new value for the parameter following the description in OCP configuration parameters.
The following describes how to edit parameters of the JSON data type.
- ① Copy to clipboard: Click the icon to copy the parameter content to the clipboard.
- ② Add a key: Click the icon to add a key to the node.
- ③ Edit a key: Click the icon to edit a key on the node.
- ④ Delete a node or a key: Click the delete icon next to a node or key to delete the node or key.
Click OK.
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 upon a restart, you must restart the OCP server for the modifications to take effect.