Change deletion frequency

  • Resolved mravat

    (@rosso711)


    3 years, 4 months ago

    Hi,

    My website uses around 35 plugins (all required in order to give in order to achieve result).

    It is a woocommerce website with a lot of customization.

    The database is now around 800MB (due to the huge number of orders – 30.000 now).

    As a result of the big number of plugins, the options table is getting relatively big in zero time. This suddenly started causing big delay problems, at a point where the website could not be loaded at all.

    I’ve noticed that clearing all transients from the options table solved the problem.

    One day though (at this point) is too long to wait until the expired transients to be deleted.

    Is there any chance that i can change the deletion time to let’s say every 2-3 hours?

    Thank you in advance!

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author webaware

    (@webaware)

    G’day mravat,

    35 active plugins isn’t huge for an eCommerce website. My own shop has 38 active plugins, many very small, and I tend to minimise plugin use — but once you start installing eCommerce and forms add-ons, they mount up.

    Your real problem here is that (at least) one of your plugins, or your theme, is abusing the transients API. If you can identify which one(s) that is, you might be able to switch to an alternative that isn’t doing that. The Transient Manager plugin can help you view transients stored in your options table, so check it out:

    https://www.ads-software.com/plugins/transients-manager/

    It’s more in your interest to do that than to continue fighting the build up of transients in the options table. If they need clearing out more than once per day, that means they are impacting the performance of your website beyond merely growing the size of your database. Running the delete queries more often just means adding more database load, when you should look at solving the cause of the problem.

    Beyond that, if you find you need to keep whichever plugin is causing the excessive growth in transients, I recommend that you upgrade your server to use a persistent object store like memcached or redis. When you use one of those with WordPress, transients are not stored in the options table at all.

    But one thing more: it sounds like you’re resolving your problems by clearing the transients manually. Are you only clearing expired transients or all transients? If your transients build up is largely not expired transients, you will have problems even with memcached or redis. You will need to identify the cause, and fix that.

    cheers,
    Ross

Viewing 1 replies (of 1 total)
  • The topic ‘Change deletion frequency’ is closed to new replies.