How to schedule a stored procedure in MySQL
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();