i have my website cron set to run hourly. it seems silly to be optimizing tables on the hour, so the attached patch adds more flexibility to when optimizations are run. a select box gives the option of running hourly, daily (default), weekly, and monthly. plus there's a link to optimize manually.

tested and works as advertized for me.

CommentFileSizeAuthor
#1 db_maintenance_cron_frequency_0.patch3.4 KBhunmonk
db_maintenance_cron_frequency.patch3.18 KBhunmonk

Comments

hunmonk’s picture

hunmonk commented
StatusFileSize
new db_maintenance_cron_frequency_0.patch3.4 KB

slight mistake in that last patch -- we need to set our own marker for the last time that the optimizations were performed, and not rely on cron_last.

attached patch corrects.

deekayen’s picture

deekayen commented
Status: Needs review » Closed (fixed)

5.x-1.2