Databases and SQL Question
Discussion
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
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
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


