Request: possibility to run optimizer every 30mins

  • Resolved Tom M

    (@tominthephilippines)


    1 month, 3 weeks ago

    Hi and thank you for this great plugin! I was handed over a website that has a rapidly growing database, due to transients mostly coming from Woocommerce. After many months I haven’t figured out what the issue is, and the web hosting only offers 250MB for the database, so it’s giving me a headache.

    Your plugin has been a big help, running the optimization every hour. Sometimes, running it every hour is still not fast enough to keep the database below 250MB. Therefore I’d like to request if the option to set the planner to run the optimization every 30 minutes could be implemented in the next update.

    Thank you in advance for considering my request.

    Best regards,
    Tom

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author NerdPress

    (@nerdpressteam)

    1 month, 1 week ago

    Hi Tom,

    A 250MB database limit, especially for a site running WooCommerce, is very low, so increasing the database optimization and transient cleanup timeframe will be a “band-aid” at best. Your site will likely also have performance issues if you’re frequently deleting transients. So I’d definitely recommend you consider upgrading your hosting.

    I think it’s unlikely other users will need or want to optimize this frequently (even _hourly_ is likely more frequently than most sites should running optimization), so we don’t plan on adding this schedule to the options.

    Having said that, here’s how you can change the schedule to every 30 minutes:

    1. Install the excellent WP Crontrol plugin.
    2. On the Cron Schedules tab, add a new schedule with an interval of 1800 seconds:

    3. Switch to the Cron Events tab, find the row with the odb_scheduler event, hover over it and click “Edit.”

    4. Adjust the recurrence to your new 30 minute schedule:

    5. That should do it! On the Cron Events page it should now show the new schedule. (Note, it may need to run once on the older schedule before it resets to 30 minutes.

    You can uninstall the WP Crontrol plugin after doing this.

    Note, if you edit the settings for Optimize Database After Deleting Revisions, and change the schedule in the drop-down, it will override the above changes.

    Hope that helps!

    Thread Starter Tom M

    (@tominthephilippines)

    1 month ago

    Hi and thank you for your reply!

    I totally agree with you that a database of max. 250MB is way too small. Unfortunately I am only offering the client maintenance services, while they chose their host when they had their website built years ago. They also contacted me to fix their database size, which went way over 250MB.

    Eventually I got that fixed, but then after a Woocommerce update the issue popped up again. For now, I believe I was able to fix the ever growing database, combined with your plugin. I might even try to set the interval to a longer time than the current 1 hour optimization.

    I want to thank you for your extended explanation, which I hopefully don’t need anymore.

    Cheers and thanks!
    Tom

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.

Tags