Databases and SQL Question
Author
Discussion

TheExcession

Original Poster:

11,669 posts

281 months

Thursday 21st June 2007
quotequote all
Platform is Linux, DB is MySQL v5.

Is there a way to get MYSQL to periodically run an SQL statement/stored procedure?

I want to run a test on a table every few seconds which purges certain records.

I don't want to do this based upon an insert or ypdate trigger because there is no guaranteee that an insert will occur within the time period.

I guess if not then I am looking at using CRON - perhaps with wget on a php page that will run my sql statement?

Any other ideas?

cheers
Ex

ETA: MYSQL 5.1 has an Event Scheduler, but unfortunately we're on 5.0.27

Edited by TheExcession on Thursday 21st June 12:49