Note
This parameter is introduced in BP2 of V4.3.5.
Description
enable_manual_storage_cache_policy specifies whether to enable the hot data cache strategy manually specified by users.
Applicability
This parameter applies only to Shared-Storage (SS) mode in OceanBase Database.
Privilege requirements
Query the parameter
The
systenant and all user tenants can execute theSHOW PARAMETERSstatement or query the parameter in theGV$OB_PARAMETERSview.Modify the parameter
The
systenant and user tenants can modify the parameter.Notice
The hot data cache strategy specified by users takes effect only in user tenants in MySQL mode. If you modify the parameter in an Oracle tenant or the
systenant for a user tenant or a non-user tenant such as thesystenant or Meta tenant, the modification succeeds but the feature does not take effect.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Bool |
| Default value | True |
| Value range |
|
| Modifiability | Yes. You can modify the parameter by using the ALTER SYSTEM SET statement. |
| Effective only after OBServer restart | No, the setting takes effect immediately. |
Examples
Enable the hot data cache strategy in a user tenant.
obclient> ALTER SYSTEM SET enable_manual_storage_cache_policy= True;Enable the hot data cache strategy for the
mysqltenanttenant in thesystenant.obclient> ALTER SYSTEM SET enable_manual_storage_cache_policy= True TENANT = mysqltenant;
References
- Set the default cache strategy: default_storage_cache_policy