Applicability
This statement is applicable only in the Shared-Storage (SS) mode.
Purpose
The ALTER SYSTEM FLUSH SS_LOCAL_CACHE statement is used to clear the local cache data of a specified type for a specified user tenant in the Shared-Storage (SS) mode.
Privilege requirements
This statement must be executed by the root user of the sys tenant. User tenants do not support this statement.
Syntax
ALTER SYSTEM FLUSH SS_LOCAL_CACHE TENANT [=] tenant_name [CACHE [=] cache_type];
cache_type:
micro_cache
| macro_cache
| mem_macro_cache
| hot_macro_cache
Parameters
| Parameter | Description |
|---|---|
| tenant_name | Specifies the user tenant whose local cache data is to be cleared. Only one tenant can be specified in a statement. |
| cache_type | Specifies the type of local cache data to be cleared. Only one type can be specified in a statement. The supported types are as follows:
If the |
Examples
In the
systenant, clear all types of local cache data for themysql_tenanttenant.obclient(root@sys)[(none)]> ALTER SYSTEM FLUSH SS_LOCAL_CACHE TENANT = 'mysql_tenant';In the
systenant, clear the local memory macroblock cache data for themysql_tenanttenant.obclient(root@sys)[(none)]> ALTER SYSTEM FLUSH SS_LOCAL_CACHE TENANT = 'mysql_tenant' CACHE = 'mem_macro_cache';