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.
Giuseppe Maxia is the MySQL community team lead.
A system analyst with 20 years of IT experience, he has worked as a database consultant and designer for several years.
He is a frequent speaker at open source events and the author of many articles.
He lives in Sardinia (Italy).
I was born in Sofia, Bulgaria in 1980. I graduated both at Technical University-Sofia, Bulgaria with MSc in Computer Engineering, and University of Applied Sciences Stuttgart, Germany with MSc in Software Technology.
I started programming at age of 12, playing with Pascal. My professional carreer started when I was 20. I started at a Web 1.0 oriented company doing development using PHP/MySQL, and later C.
I joined MySQL AB in 2005 after I did my master thesis, Temporal Triggers for MySQL, during my internship at MySQL. I have been involved in QA, Event scheduler implementation (my thesis) which will be available in 5.1, Server bug-fixing and since 2 years part of the connectors team.
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at email@example.com
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at firstname.lastname@example.org
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.