Applicability
This statement is only applicable to the Shared-Storage (SS) mode.
Purpose
The ALTER SYSTEM FLUSH ss_micro_cache statement is used to clear the microblock cache data for a specified 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_micro_cache TENANT [=] tenant_name;
Parameters
| Parameter | Description |
|---|---|
| tenant_name | Specifies the user tenant whose microblock cache data needs to be cleared. Only one tenant can be specified in a statement. |
Examples
In the sys tenant, clear the microblock cache data for the mysql_tenant tenant.
obclient> ALTER SYSTEM FLUSH ss_micro_cache TENANT = 'mysql_tenant';