event_scheduler

Overview

Enable the event scheduler. Possible values are ON, OFF, and DISABLED (keep the event scheduler completely deactivated, it cannot be activated run-time)

See also: System Variables for MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES

USAGE

The event_scheduler system variable can have its default value configured via SkySQL Configuration Manager.

DETAILS

The event_scheduler system variable controls the status of the event scheduler.

  • If the event_scheduler system variable is OFF, then the event scheduler's thread will not exist, and no events will be executed.

  • If the event_scheduler system variable is ON, then the event scheduler's thread will exist, and events will be executed as scheduled.

  • If the event_scheduler system variable is DISABLED, then the event scheduler's thread will not exist, no events will be executed, and enabling the event scheduler will require the service to be restarted.

  • If the event_scheduler system variable is dynamically set to the special value ORIGINAL, then its value will revert to the value from the last service restart.

PARAMETERS

Dynamic

Yes

Scope

Global

Data Type

ENUM (OFF, ON, DISABLED, ORIGINAL)

Default Value

OFF

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

Multi-Node Analytics

10.5

OFF (choices: ON, OFF)

Single Node Analytics

10.5

OFF (choices: ON, OFF)

Distributed Transactions

10.5

Not present

10.6

Not present

Replicated Transactions

10.4

OFF (choices: ON, OFF)

10.5

OFF (choices: ON, OFF)

10.6

OFF (choices: ON, OFF)

Single Node Transactions

10.4

OFF (choices: ON, OFF)

10.5

OFF (choices: ON, OFF)

10.6

OFF (choices: ON, OFF)

GCP

Multi-Node Analytics

10.5

OFF (choices: ON, OFF)

Single Node Analytics

10.5

OFF (choices: ON, OFF)

Distributed Transactions

10.5

Not present

10.6

Not present

Replicated Transactions

10.4

OFF (choices: ON, OFF)

10.5

OFF (choices: ON, OFF)

10.6

OFF (choices: ON, OFF)

Single Node Transactions

10.4

OFF (choices: ON, OFF)

10.5

OFF (choices: ON, OFF)

10.6

OFF (choices: ON, OFF)

PRIVILEGES

The event_scheduler system variable requires the SUPER privilege to dynamically set its value at runtime.

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES