Note
This variable is available starting with V4.1.0.
Description
regexp_time_limit specifies the maximum execution time limit for regular expression matching operations, in milliseconds.
Privilege requirements
Query variables
systenants and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the values of global system variables.Modify variables
systenants can directly modify the values of global system variables.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the values of global system variables.Oracle user tenants must have the
ALTER SYSTEMprivilege to modify the values of global system variables.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 32 |
| Value range | [0, 2147483647] |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the maximum execution time limit for regular expression matching operations to 32 ms.
obclient> SET GLOBAL regexp_time_limit = 32;