Note
- For V4.6.x, this parameter is available starting with V4.6.0.
- For V4.4.x, this parameter is available starting with V4.4.2.
- For V4.2.5, this parameter is available starting with V4.2.5 BP5.
Description
enable_gts_standalone specifies whether to enable the GTS service to occupy a dedicated group of units. Enabling this feature can improve the performance and stability of the GTS service.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Bool |
| Default value | False |
| Value range |
|
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No |
Considerations
The GTS service of a tenant is provided by the unit that hosts the system log stream. When the GTS service and user log stream are in the same unit, the GTS service may be affected by the access pressure and maintenance operations of the user log stream. To prevent the GTS service from affecting the overall availability of the tenant, OceanBase Database provides the feature to enable the GTS service to occupy a dedicated group of units.
After you enable the GTS service to occupy a dedicated group of units, the load balancing feature automatically selects a group of units to host the system log stream (preferably the unit list specified in the log stream maintenance command or the current unit list). The user log stream is then automatically distributed across other units.
After you enable the GTS service to occupy a dedicated group of units, ensure that the UNIT_NUM value of each zone of the tenant is at least 2 and that the enable_rebalance parameter is enabled.
Examples
Enable the GTS service to occupy a dedicated group of units.
obclient> ALTER SYSTEM SET enable_gts_standalone = 'True';