suspend_storage_cache_task

Last Updated:2026-09-03 07:27:36

This parameter is introduced in BP2 of V4.3.5.

Description

suspend_storage_cache_task specifies whether to suspend background cache tasks.

This parameter applies only to Shared-Storage (SS) mode in OceanBase Database.

Query the parameter

The sys tenant and all user tenants can execute the SHOW PARAMETERS statement or query the parameter in the GV$OB_PARAMETERS view.
Modify the parameter

The sys tenant 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 sys tenant modifies this parameter for a user tenant in MySQL mode or another non-user tenant (including the sys tenant and the Meta tenant), the modification succeeds but the feature does not take effect.

Attribute	Description
Parameter type	Bool
Default value	False
Value range	`True`: Suspends the current cache tasks and newly initiated cache tasks. `False`: Does not suspend background cache tasks, that is, allows cache tasks to proceed normally.
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.

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 mysqltenant tenant.

obclient> ALTER SYSTEM SET suspend_storage_cache_task = True TENANT = mysqltenant;

Resume cache tasks in the mysqltenant tenant.

 obclient> ALTER SYSTEM SET suspend_storage_cache_task = False TENANT = mysqltenant;

Previous topic

Next topic