Note
- For V4.4.x, this parameter is available starting with V4.4.0.
- For V4.3.5, this parameter is available starting with V4.3.5 BP2.
Description
enable_manual_storage_cache_policy specifies whether to enable the user-defined hot data caching policy.
Applicability
This parameter is available only in OceanBase Database Shared-Storage (SS) mode.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query the value of this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
The
systenant and user tenants can modify this parameter.Notice
If you are in Oracle-compatible mode, you cannot enable the hot data caching policy. If you modify this parameter in an Oracle-compatible mode user tenant or specify an Oracle-compatible mode user tenant or other non-user tenant (such as the
systenant or the Meta tenant) to modify this parameter, the parameter value can be modified, but the hot data caching policy is not enabled.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Bool |
| Default value | True |
| Value range |
|
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Examples
Enable the user-defined hot data caching policy in the user tenant.
obclient> ALTER SYSTEM SET enable_manual_storage_cache_policy= True;Enable the user-defined hot data caching policy for the
mysqltenanttenant in the system tenant.obclient> ALTER SYSTEM SET enable_manual_storage_cache_policy= True TENANT = mysqltenant;
References
- Set the default caching policy: default_storage_cache_policy