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