1
vote
Accepted
I created an event, but it is never executed. Why?
Ensure the event scheduler is enabled. Variable 'event_scheduler' is a GLOBAL variable and should be set with SET GLOBAL as follows:
SET GLOBAL event_scheduler = ON ;
Verify,
SHOW GLOBAL VARIABLES ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
mysql × 22474innodb × 2006
performance × 1742
database-design × 1452
mariadb × 1410
replication × 1368
mysql-5.5 × 945
query-performance × 870
mysql-5.7 × 842
mysql-5.6 × 836
index × 817
join × 753
optimization × 719
mysqldump × 658
backup × 552
php × 551
mysql-8.0 × 522
myisam × 479
select × 455
query × 435
trigger × 426
mysql-workbench × 422
amazon-rds × 399
stored-procedures × 381
linux × 348