SHOW VARIABLES LIKE '%sche%';
SET GLOBAL event_scheduler=1;
SHOW VARIABLES LIKE '%sche%';
DELIMITER $$
CREATE EVENT `evt_optimize_table`
ON SCHEDULE EVERY 2 MONTH
/* uncomment the example below you want to use */
DO
BEGIN
CALL p_optimize_table();
END$$
DELIMITER ;
SET GLOBAL event_scheduler=1;
SHOW VARIABLES LIKE '%sche%';
DELIMITER $$
CREATE EVENT `evt_optimize_table`
ON SCHEDULE EVERY 2 MONTH
/* uncomment the example below you want to use */
DO
BEGIN
CALL p_optimize_table();
END$$
DELIMITER ;