Brings site to a crawl creating autoload transients in wp_options

  • Just posting this in case other’s run into it. I’ve switched to another solution.

    This plugin seems to set 1000’s of transients in the wp_options with autoload set to yes. Which within a few days means every page load was autoloading 5000 options. Yikes.

    I temporaryily fix would be to set these to not autoload
    UPDATE wp_options SET autoload=’No’ WHERE option_name LIKE “_transient_%”

    However, after that it just created 1000’s of new transients within a few days.

    I gave up before looking at fixing the code, but it shouldn’t be too hard a fix.

Viewing 1 replies (of 1 total)

  • Thanks for this. I had taken this plugin off over a year ago but hadn’t looked at my db ever. After doing a bit of searching, I found the transients that you mentioned set to Autoload. As I have other transients set to autoload and I don’t know the side effects of changing ALL of them, I’m going to only set ‘NO’ on option_name LIKE ‘transient_bawmrp’.

    I am disappointed that uninstalling doesn’t usually clean up db tables so I have all sorts of disused tables in my db. As I have no experience with this, I let the tables stay as I don’t want to “break” the blog and I don’t necessarily trust plugins to ‘attack’ my db and potentially damage my blog.

Viewing 1 replies (of 1 total)
  • The topic ‘Brings site to a crawl creating autoload transients in wp_options’ is closed to new replies.