MySQL Forums
Forum List  »  Events (Job Scheduler)

Mysql-5.6.16 Event Scheduler skip to invoke
Posted by: Sunil Divyeshvar
Date: March 09, 2014 11:06PM

Hello,

I have scheduled one particular event for every 15 seconds.
i am facing problem that sometime event scheduler does not invoke and does not execute any of the event on any database.

by searching in detail i found that sometimes query from event took much time to execute so next cycle of that particular event (i.e. after 15 seconds) took place and it is not allowing to execute any event on any database.

i want to know is that possible that particular event take too much time to execute and that same event's next schedule cycle arrives to execute it again and at that time event_scheduler not allow to execute any event on any database bcs previoues event is still running ?

i am using mysql-5.6.16 and cent-os-6.4

Thanks



Edited 1 time(s). Last edit at 03/09/2014 11:07PM by Sunil Divyeshvar.

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql-5.6.16 Event Scheduler skip to invoke
2536
March 09, 2014 11:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.