Home / server / Questions / 328241
Accepted
Lucas Kauffman
Asked: 2011-11-07 03:00:42 +0800 CST

MySQL scheduler

  • 772

Every time I restart the MySQL server, the event scheduler gets dissabled.

I can't find any variable in the my.cnf to enable this, does anyone know a solution ?

mysql event-scheduler

1 Answers

  1. Best Answer

    Take a look at the event_scheduler option.

    You can start it with:

    mysql> SET GLOBAL event_scheduler = ON;

    You have to add:

    event_scheduler=ON

    to the /etc/my.cnf under the [mysqld] section for permanent.

    • 1