Topic: Short of a cron job, need a recurring event to schedule db maintenance · BuddyPress.org

Skip to:: Content; Pages; Categories; Search; Top; Bottom

Short of a cron job, need a recurring event to schedule db maintenance

Erwin Gerrits
Participant

@egerrits

14 years, 9 months ago

I need to perform regular maintenance (once a day or so) on my database. I do not want users to set up a cron job to do this, so what would be a suitable wp or buddypress “event” (or hook) that would give me a reasonable frequence of occurring, without it occurring every time each user clicks on anything.

I suppose it would be something happening when the admin logs into the back-end or something once a day type of thing.

Any ideas?

Viewing 4 replies - 1 through 4 (of 4 total)

Simon
Participant

@conceptfusion

14 years, 8 months ago

Could you not just use a high traffic event and put some basic logic around it?

Perhaps a check to see if a given timestamp has passed? You could create a simple db table and add the timestamp as a “flag” updating it when the criteria is met and the action completed, thus re-setting the task schedule for the next time-stamped period.

Burt Adsit
Participant

@burtadsit

14 years, 8 months ago

wp has: https://codex.wordpress.org/Category:WP-Cron_Functions

meenotuss
Participant

@meenotuss

14 years, 8 months ago

I found a great plugin in the repsitory wp-dbmanager.2.50, seems to do everything you would want with your database

Erwin Gerrits
Participant

@egerrits

14 years, 8 months ago

wp-cron functions would do it! Thanks for your suggestions!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Short of a cron job, need a recurring event to schedule db maintenance’ is closed to new replies.