Mysql Event Not Working
Events are run by the scheduler, which is not started by default. Using SHOW PROCESSLIST is possible to check whether it is started. If not, run the command SET GLOBAL event_scheduler = ON; to run it.
Events are run by the scheduler, which is not started by default. Using SHOW PROCESSLIST is possible to check whether it is started. If not, run the command SET GLOBAL event_scheduler = ON; to run it.
You can use mysql scheduler to run it each 5 seconds. You can find samples at http://dev.mysql.com/doc/refman/5.1/en/create-event.html Never used it but I hope this would work: CREATE EVENT myevent ON SCHEDULE EVERY 5 SECOND DO CALL delete_rows_links();