Skip navigation links

MySQL Forums :: Events (Job Scheduler) :: Can an event run again if it is already running?


Advanced Search

Can an event run again if it is already running?
Posted by: Glenn Schworak ()
Date: April 21, 2012 04:00PM

I have started working with events and until now they have all been daily clean-up events that don't take long to run.

I have an idea for a new event that I want to run every 10 minutes (or so). But the catch is, in some cases (not often) the run time on the event can take well over 10 minutes and it has a high processor load.

If I schedule this event to run every 10 minutes (for example) and it is alreay running, will I end up with two copies of the event running and hammer my processor? or will the scheduler see that the event is still running from the last time and skip execution?

If it will just fire off another copy of the event, how can I prevent this?

Options: ReplyQuote


Subject Views Written By Posted
Can an event run again if it is already running? 1860 Glenn Schworak 04/21/2012 04:00PM


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.