event_scheduler¶

MatrixOne does not support the MySQL CREATE EVENT statement or the event scheduling subsystem. The event_scheduler system variable exists for MySQL compatibility but always returns DISABLED, indicating that event execution is not available in MatrixOne. This variable is read-only and its value cannot be changed.

The event_scheduler system variable indicates whether the MySQL Event Scheduler is enabled. In MatrixOne, CREATE EVENT and event scheduling are not supported, so this variable always returns DISABLED.

Syntax¶

Query the event_scheduler variable:

SHOW VARIABLES LIKE 'event_scheduler';
SELECT @@event_scheduler;
SELECT @@global.event_scheduler;

The variable cannot be set — it is read-only and always returns DISABLED.

Arguments¶

Property	Value
Variable Type	`enum`
Scope	`Global`
Dynamic	`No`
Default Value	`DISABLED`
Optional Value	`DISABLED`

Examples¶

DROP DATABASE IF EXISTS event_scheduler_demo;
CREATE DATABASE event_scheduler_demo;
USE event_scheduler_demo;

SHOW VARIABLES LIKE 'event_scheduler';
SELECT @@event_scheduler;
SELECT @@global.event_scheduler;

DROP DATABASE event_scheduler_demo;

The output will show DISABLED for all three queries:

Variable_name    | Value
event_scheduler  | DISABLED

Constraints¶

MatrixOne does not support CREATE EVENT or event scheduling. The event_scheduler system variable is read-only and always returns DISABLED.
Setting event_scheduler to any other value has no effect.