Using the Event Scheduler: The Friendly Behind-the-Scenes Helper Giuseppe Maxia (Sun Microsystems Inc), Andrey Hristov (SUN Microsystems) Using the Event Scheduler: The Friendly Behind-the-Scenes Helper Giuseppe Maxia (Sun Microsystems Inc), Andrey Hristov (SUN Microsystems) Download the PDF slides at http://assets.en.oreilly.com/1/event/21/Using%20the%20Event%20Scheduler_%20The%20Friendly%20Behind-the-Scenes%20Helper%20Presentation.pdf From the official conference description at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7115 The Event Scheduler is a framework for executing SQL commands at specific times or at regular intervals. The basics of its architecture are simple. An event is a stored routine with a starting date and time, and a recurring tag. Once defined and activated, it will run when requested. Unlike triggers, events are not linked to specific table operations, but to dates and times. Using the event scheduler, the database administrator can perform recurring events with minimal hassle. Common occurrence are the cleanup of obsolete data, the creation of summary tables for statistics, the monitoring of server performance and usage. This session will show how to create events, and how to deal with their limitations and tricky points. Examples shown during this session include the normal ones, and some hacks, like executing external commands with the event scheduler, monitoring replication servers, executing parallel queries.