Bug #2370 Task Planning
Submitted: 13 Jan 2004 7:36 Modified: 6 Mar 2006 13:36
Reporter: Federico Razzoli (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5 OS:Any (All)
Assigned to: CPU Architecture:Any

[13 Jan 2004 7:36] Federico Razzoli 
Description:
Please, implement a system for SQL queries planning. So one can execute - for example - OPTIMIZE once a week. But it should also support queries like:

TRUNCATE TABLE abc
INSERT INTO abc SELECT ...
LOAD DATA INFILE ...

Would this slow MySQL? If so, maybe one should be able to turn off this feature...

How to repeat:
NA

Suggested fix:
NA
[13 Jan 2004 11:29] Sergei Golubchik 
we have this in the todo. The syntax is being worked on yet (and you are welcome to come with your ideas), but basically it will be something like internal cron-like process (a "process" from user point of view, not an OS process, of course, more likely a thread). So it will be able to start a stored procedure periodically or once.
[6 Mar 2006 13:36] Peter Gulutzan 
We have added this feature in MySQL version 5.1.
See the new chapter in the version-5.1 manual entitled "Event Scheduler".
http://dev.mysql.com/doc/refman/5.1/en/events.html