Mysql event scheduler issue

Imagen de melvinlopez06
0 puntos

i have a headache with this issue.
I have a ubuntu server (9.10) using LAMP, two weeks ago was configured an intranet system, it use mysql events on his database.

Ok, fine, I did configure the my.cnf file, and added this line
event_scheduler = on, to activate the event scheduler proccess for mysql.

My surprise was to reboot mysql services, event_scheduler did not work.
I checked the variables and process list and event scheduler was turn off.

Then I reboot the server and event scheduler still off.
The only way to run event scheduler is open a mysql console and execute the query:
SET GLOBAL event_scheduler=ON;

I dont know why mysql starts with event_scheduler=off if the config file (my.cnf) is on.