Note
This parameter is introduced in BP2 of V4.3.5.
Description
suspend_storage_cache_task specifies whether to suspend background cache tasks.
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
Due to the fact that the manual hot data cache strategy only takes effect in MySQL mode, if you modify this parameter in Oracle mode or if the
systenant modifies this parameter for a user tenant in MySQL mode or another non-user tenant (including thesystenant and the Meta tenant), the modification succeeds but the feature does not take effect.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Bool |
| Default value | False |
| Value range |
|
| Modifiability | Yes. You can modify the parameter by using the ALTER SYSTEM SET statement. |
| OBServer node restart required for take effect | No. The setting takes effect immediately. |
Examples
User tenant
Suspend cache tasks in the current tenant.
obclient> ALTER SYSTEM SET suspend_storage_cache_task = True;Resume cache tasks in the current tenant.
obclient> ALTER SYSTEM SET suspend_storage_cache_task = False;
sys tenant
Suspend cache tasks in the
mysqltenanttenant.obclient> ALTER SYSTEM SET suspend_storage_cache_task = True TENANT = mysqltenant;Resume cache tasks in the
mysqltenanttenant.obclient> ALTER SYSTEM SET suspend_storage_cache_task = False TENANT = mysqltenant;