Note
ob_reserved_meta_memory_percentage is available starting with V2.2.77.
Description
ob_reserved_meta_memory_percentage specifies the percentage of reserved memory for the tenant. It mainly stores the Meta-related structural information.
Privilege requirements
Query variables
sysand all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLE(Oracle mode) orinformation_schema.GLOBAL_VARIABLES(MySQL mode) view to view the value of a global system variable.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 |
| Valid value range | [1,100) |
| Valid scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the percentage of reserved memory for the tenant to 10.
obclient> SET GLOBAL ob_reserved_meta_memory_percentage= 10;