Loading...

Using the Event Scheduler: The Friendly Behind-the-Scenes Helper

953 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jul 21, 2009

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/...

From the official conference description at http://www.mysqlconf.com/mysql2009/pu...

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.

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...