Overview
default_storage_cache_policy specifies the default cache policy, which is the default value of the tenant-level storage_cache_policy parameter. This parameter takes effect only for newly created tables.
Privilege requirements
Query parameters
The
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Both the
systenant and user tenants can modify this parameter.Notice
The manual hot data caching strategy setting takes effect only in user tenants. When you modify this parameter in non-user tenants (
systenant and Meta tenant), the parameter value is updated, but the feature does not take effect.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | String |
| Default Value | AUTO |
| Value range |
|
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
- For all newly created tables in the current tenant that do not have a cache policy explicitly specified via the
storage_cache_policyparameter, the cache policy specified indefault_storage_cache_policyis used by default. - Only user tables and indexes are affected by the
default_storage_cache_policyparameter. System tables are not affected by this parameter and always use theAUTOconfiguration.
Configuration example
In the user tenant, set the default cache policy for this tenant to
HOT.obclient> ALTER SYSTEM SET default_storage_cache_policy='HOT';The default cache strategy for the specified tenant
mysqltenantunder the system tenant is set toHOT.obclient> ALTER SYSTEM SET default_storage_cache_policy='HOT' TENANT = mysqltenant;