MySQL timer EVENT study notes

The constant GLOBAL event_scheduler must be on or 1 for timing to work

-- Check to see if the timer is on
SHOW VARIABLES LIKE '%sche%';

-- Start timer 0: off 1: on
SET GLOBAL event_scheduler = 1;

-- Create event
-- The e_test() stored procedure is automatically called every 1 second
CREATE EVENT IF NOT EXISTS event_test
ON SCHEDULE EVERY 1 SECOND
ON COMPLETION PRESERVE
DO CALL e_test();

-- Open event
ALTER EVENT event_test ON
COMPLETION PRESERVE ENABLE;

-- Close event
ALTER EVENT event_test ON
COMPLETION PRESERVE DISABLE;

SELECT * FROM t;