Note
This variable is available starting with V4.1.0.
Description
regexp_stack_limit specifies the maximum available memory for the internal stack used in regular expression matching operations. The unit is bytes.
Privilege requirements
Query variables
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle-compatible mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to view the value of Global system variables.Modify variables
systenants can directly modify the value of Global system variables.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the value of Global system variables.Oracle user tenants must have the
ALTER SYSTEMprivilege to modify the value of Global system variables.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 8000000 |
| Value range | [0, 2147483647] |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the maximum available memory for the internal stack used in regular expression matching operations to 10 MB.
obclient> SET GLOBAL regexp_stack_limit = 10 * 1024 * 1024;