Bug #81980 load_events_from_db called at startup, not thread init
Submitted: 23 Jun 2016 0:45 Modified: 28 Jun 2016 15:27
Reporter: Trey Raymond Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: DML Severity:S4 (Feature request)
Version:5.6, 5.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: event scheduler

[23 Jun 2016 0:45] Trey Raymond
The function to sync up the in-memory event repository from the state of the db on disk:
Useful bit of code, but to call it, you need to restart the server.  The only reference to it is in the event init function:
Pretty simple job to require downtime.

How to repeat:

Suggested fix:
on event scheduler thread start (i.e. set global event_scheduler=1), have load_events_from_db called.  can use existing mutex to protect it (don't want to risk a conflict with a create/alter/drop).
[28 Jun 2016 15:27] MySQL Verification Team
This is fully justified feature request.