title: How can I get MySQL to run queries on an interval?
body: <p>I'm creating a web application where every row of a table needs to be processed. I'm spawning one child PHP process per table row. I'm implementing a safety mechanism, so if a PHP process is interrupted processing a row, a new PHP process will spawned to process said row. To do this I'm going to create a new table where all PHP processes check in every 10 seconds or so. I need MySQL to delete all rows that haven't been checked into for 5 minutes or more, so my application will know to create a new PHP child to process that row.</p>
  
  <p>I know it's possible to get MySQL to run queries on an interval, but I don't know how.</p>
  
  <p>~Enter stackoverflow~</p>
  
  <hr>
  
  <p>Edit: I was hoping to learn how to do this 100% MySQL. Is there no way to set MySQL to run a query every hour, or at a specific time each day or such?</p>