MySQL Events
MySQL Events are scheduled tasks that run SQL statements at defined times or intervals — like cron jobs inside the database. They require the Event Scheduler to be running.
MySQL
Beginner
3 min read
MySQL Events Overview
Example
-- Enable event scheduler (my.cnf or session)
SET GLOBAL event_scheduler = ON;
SHOW VARIABLES LIKE "event_scheduler";
-- List all events
SHOW EVENTS;
-- List events in a database
SHOW EVENTS FROM mydb;
-- Simple one-time event
CREATE EVENT cleanup_log
ON SCHEDULE AT NOW() + INTERVAL 1 HOUR
DO DELETE FROM logs WHERE created_at < NOW() - INTERVAL 30 DAY; Pro Tip
Set event_scheduler = ON in my.cnf so it survives restarts — it defaults to OFF.