You can configure an OceanBase cluster by setting cluster parameters to ensure that the behaviors of OceanBase Database meet your service requirements.
OceanBase Database supports cluster parameters that apply to the entire cluster. Some parameter settings take effect in real time and some take effect only after a restart. You can set cluster parameters to control the load balancing strategy, compaction time, compaction method, resource allocation, and module switches of a cluster.
The sys tenant can view and set cluster parameters. A user tenant can only view cluster parameters.
If you do not specify the parameters, the default values are used after the OBServer node is started. Upon the successful start of the OBServer node, the parameter values are permanently saved to the /home/admin/oceanbase/etc/observer.config.bin file. You can run the strings observer.config.bin command to view the file content.
Different cluster parameters are of different data types. The following table describes the data types of cluster parameters in OceanBase Database.
| Data type | Description |
|---|---|
| BOOL | The Boolean value. Valid values: true and false. |
| CAPACITY | The unit of capacity. Valid values: b (bytes), k (KB), m (MB), g (GB), t (TB), and p (PB). The unit is case-insensitive. Default value: m. |
| DOUBLE | The Double (double-precision floating-point) type. A value of this data type occupies a storage space of 64 bits, has 16 valid digits, and is accurate to 15 digits after the decimal point. |
| INT | The Int64 type. A value of this data type can be a positive integer, negative integer, or 0. |
| MOMENT | The type that represents a moment in the hh:mm format, such as 02:00. Special value: disable, which indicates that no time is specified. This data type applies only to the major_freeze_duty_time parameter. |
| STRING | Strings. The user-specified string value. |
| STRING_LIST | The type that represents a list of strings separated with semicolons (;). |
| TIME | The time type. The following time units are supported: us (microseconds), ms (milliseconds), s (seconds), m (minutes), h (hours), and d (days). If no suffix is added to a value of this data type, the unit s is used by default. The unit is case-insensitive. |
More information
For more information about how to view and set tenant parameters, see the following topics: