Note
This variable is available starting with V2.2.77.
Description
ob_reserved_meta_memory_percentage specifies the percentage of memory reserved for a tenant, which is mainly used to store Meta-related structure information.
Privilege requirements
Query variables
You can execute the
SHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) orinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to obtain the value of a Global system variable. Thesystenant and all user tenants can perform this operation.Modify variables
The
systenant can directly modify the value of a Global system variable.A MySQL user tenant must have the
SUPERorALTER SYSTEMprivilege to modify the value of a Global system variable.An Oracle user tenant must have the
ALTER SYSTEMprivilege to modify the value of a Global system variable.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 10 |
| Value range | [1,100) |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the percentage of memory reserved for a tenant to 10.
obclient> SET GLOBAL ob_reserved_meta_memory_percentage= 10;