Using the Event Scheduler: The Friendly Behind-the-Scenes Helper
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.
People planning to attend this session also want to see:
Giuseppe Maxia
Sun Microsystems
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).
Andrey Hristov
SUN Microsystems
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.
Co-presented By:
Sponsorship Opportunities
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com
Download the MySQL Sponsor/Exhibitor Prospectus
Media Partner Opportunities
Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com
Press and Media
For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com
MySQL Conference Newsletter
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
Contact Us
View a complete list of MySQL contacts.
O'Reilly Home | Privacy Policy | Contact Us | Sitemap | conf-webmaster@oreilly.com
Event Software Powered by Expectnation
© 2009, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938
Comments
The video is now on YouTube for much easier viewing:
www.youtube.com/watch?v=-Cm...
Download the 145 Mb .mov file at technocation.org/node/754/d... or, if you are more patient, wait (15-20 min) for the streaming to occur at technocation.org/node/754/play
Kevin, I don’t know what you mean by the “online help”. The manual definitely knows about CREATE EVENT and if you type “help create event” in the command line client, you get the syntax you need.
Well, I was wrong about that. While the docs say 5.1.6, and the 5.1.34 online help doesn’t know about CREATE EVENT, it does work in 5.1.34. Very confusing…
It was a great presentation which gave me many ideas about how I could usefully employ events on my applications, but the event scheduler is (according to the 5.1 documentation) not available until release 5.1.6. The current production (GA) release is 5.1.34, which definitely doesn’t include the event scheduler.