Creating Event in MySQL does not work

Question

I am creating an event (like crone job) in MySQL to execute a query every 3 seconds but does not work. I tried my best. Here is my code please see if I am doing anything wrong

CREATE EVENT `croneJob` 
ON SCHEDULE EVERY 3 SECOND 
STARTS '2014-03-24 13:45:57' 
ON COMPLETION PRESERVE ENABLE 
DO 
insert into ranktable values (1,2,3);

It successfully creates it but does not execute every 3 seconds

Pablo Francisco Pérez Hidalgo · Accepted Answer · 2014-03-24 08:52:17Z

2

You have to start your MySQL server events scheduler:

SET GLOBAL event_scheduler = ON;

Loot at:

https://dev.mysql.com/doc/refman/5.1/en/events-configuration.html

answered Mar 24, 2014 at 8:52

Pablo Francisco Pérez Hidalgo

27.8k8 gold badges39 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JDGuide · Accepted Answer · 2014-03-24 09:11:34Z

2

As I know all events are executed by a special event scheduler thread.When we refer to the Event Scheduler, we actually refer to this thread.There is global event_scheduler system variable determines whether the Event Scheduler is enabled and running on the server.

Try to set the event_Scheduler on your command line.

SET GLOBAL event_scheduler = ON;

OR

SET GLOBAL event_scheduler = 1;

Comments

Abdul Jabbar · Accepted Answer · 2014-03-24 09:38:59Z

0

Even setting

SET GLOBAL event_scheduler = ON;

was not working so I put these lines in my.ini

[mysqld]
event_scheduler = ON

and is working great now.

answered Mar 24, 2014 at 9:38

Abdul Jabbar

6,0019 gold badges57 silver badges83 bronze badges

Collectives™ on Stack Overflow

Creating Event in MySQL does not work

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related