clear_general_log

c.sql

DELIMITER $$
CREATE PROCEDURE clear_general_log()
BEGIN
SET GLOBAL general_log=0;
RENAME TABLE `general_log` TO `general_log_temp`;
DELETE FROM `general_log_temp` WHERE `event_time` < DATE(NOW() - INTERVAL 1 DAY);
RENAME TABLE `general_log_temp` TO `general_log`;
SET GLOBAL general_log=1;
END$$
DELIMITER ;