Bug #27721 In current Event Scheduler you cannot relate one temporal event to another one
Submitted: 9 Apr 2007 20:12 Modified: 29 May 2012 13:55
Reporter: Jacob Nikom Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S4 (Feature request)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any

[9 Apr 2007 20:12] Jacob Nikom
Description:
In current Event Scheduler implementation you 
cannot relate one temporal event to another one.  

For example, it would be useful if you could 
set up one event start up time to be 30 minutes 
later than another one and when the first event 
start up time is changed, the referring event 
start up time is going to change automatically.

This way you could check the time relations between 
monitoring events, organize events into groups by 
referring them to the same event, create event
synchronization and so on.

Most of scenarios center around the need to manage 
multiple groups of clients. You want to send one 
message to one group, another message to another 
group. Within the group you want to send similar, 
but slightly different messages to each client.

For example, you have Internet gaming, where you 
have multiple players participating in different 
games. You can track them and check how are they
doing relative to the start time of the game.

I also think that this functionality is not very 
difficult to implement.  You just have to register 
the referring event to the base event - that is it. 
When the base event changes its time it knows who 
is registered and just runs "Alter
event" command.

Thank you,

Jacob Nikom

How to repeat:
It is feature request!
[29 May 2012 13:55] Valeriy Kravchuk
Thank you for the feature request.