mySQL EVENTS

General Programming
1

I have a periodic timer in my mySQL database, supposed to do something every minute unless stopped.

It seems that ENABLE and DISABLE for mySQL events just stops the action from happening, doesn’t reset the timer.

Would I have to DROP and CREATE the event each time to reset the timer?

2

Never used them
I usually scheduled this as a cron task etc
But after a read of things it makes sense that disable simply skips execution and the next time period that comes around on the same schedule
Seems to me that you would have to drop & recreate to get the event rescheduled

Have you tried Alter event which seems to let you alter the schedule
https://dev.mysql.com/doc/refman/8.0/en/alter-event.html

3

Yes, ALTER is what I was using to enable and disable. It does not reset the timer.
Maybe using something like:

ALTER EVENT `myEvent`
ON SCHEDULE
EVERY 1 MINUTE STARTS CURRENT_TIMESTAMP + INTERVAL 1 MINUTE

Would restart it…
Pretty freaking verbose!!

4

This works, BTW.