CREATE EVENT monthly_delete_audit_rows
ON SCHEDULE EVERY 1 MONTH STARTS '2018-06-01'
DO BEGIN
DELETE FROM invoices_audit
WHERE action_date < NOW() - INTERVAL 1 MONTH;
END//
Delete all actions over 1 month old