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

HA (Primary/Replica)

10.4

OFF (choices: ON, OFF)

AWS

HA (Primary/Replica)

10.5

OFF (choices: ON, OFF)

AWS

Transactional Standalone

10.4

OFF (choices: ON, OFF)

AWS

Transactional Standalone

10.5

OFF (choices: ON, OFF)

AWS

Distributed Transactions

10.5

Not present (choices: ON, OFF)

GCP

ColumnStore

10.5

OFF (choices: ON, OFF)

GCP

ColumnStore Multi

10.5

OFF (choices: ON, OFF)

GCP

Galera

10.4

OFF (choices: ON, OFF)

GCP

Galera

10.5

OFF (choices: ON, OFF)

GCP

HA (Primary/Replica)

10.4

OFF (choices: ON, OFF)

GCP

HA (Primary/Replica)

10.5

OFF (choices: ON, OFF)

GCP

HTAP

10.5

OFF (choices: ON, OFF)

GCP

Transactional Standalone

10.4

OFF (choices: ON, OFF)

GCP

Transactional Standalone

10.5

OFF (choices: ON, OFF)

GCP

Distributed Transactions

10.5

Not present (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