Note
For V4.6.0, this parameter is available starting with V4.6.0.
Description
The storage_cache_clean_macro_interval parameter specifies the execution frequency of the macroblock-level cache cleaning task in Shared-Storage (SS) mode.
In SS mode, the system caches hot data in the local storage to improve access performance. Over time, some cached macroblocks may no longer be hot data and need to be periodically cleaned to release cache space. This parameter specifies the scheduling interval of the cache cleaning task.
Applicability
This parameter is applicable only in Shared-Storage (SS) mode.
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 |
|---|---|
| Type | Time |
| Default value | 24h |
| Value range | [0s, +∞) |
| 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
Set the scheduling interval of the storage cache cleaning macroblock task to 12 hours.
obclient> ALTER SYSTEM SET storage_cache_clean_macro_interval = '12h';