Note
For OceanBase Database V4.3.5, this variable takes effect starting from V4.3.5 BP2.
Description
event_scheduler specifies whether to enable and run the event scheduler on the server.
Applicability
This variable applies only to the MySQL mode of OceanBase Database.
Privileges
Query variables
The
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) and theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to check the values of global system variables.Modify variables
The
systenant can directly modify the value of a global system variable.MySQL tenants need to have the
SUPERorALTER SYSTEMprivilege to modify the value of a global system variable.Oracle tenants need to have the
ALTER SYSTEMprivilege to modify the value of a global system variable.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Bool |
| Default value | OFF |
| Value range |
|
| Scope | Global |
| Modifiability | Yes |
Examples
Execute the following statement to enable the event scheduler:
obclient> SET GLOBAL event_scheduler=ON;