DISQUS

David Risley: Fighting The Wordpress Dragons

  • Dave Doolin · 2 months ago
    I just spent an hour this morning culling plugins. Not done yet either, plan on culling a few more. The admin interface is just too slow. Removing a lot of plugins helped, a little.

    Didn't think to check the options table. That will be a next task. I also have a bbPress installation that isn't being used, so that needs to go as well.

    Thanks for such a useful post, this definitely will help me speed up my WordPress.

    -d
  • ericabiz · 2 months ago
    Hi David,

    Just wanted to let you know that my boyfriend, Richard, also consults and does this sort of stuff for a living -- tracking down weird code bugs for high-performance sites. I'm sure he would be happy to work with you to figure out the Apache issue. You can reach him @floatingatoll on Twitter or contact me offline and I will get you his contact info!
  • cbahm · 2 months ago
    If a plug-in is de-activated AND removed, does it still leave crap in your wp_options table?

    Thx for this post -- good info.
  • Dave Doolin · 2 months ago
    @cbahm:

    A WordPress plugin may or may not leave options in the options table. It depends on the how the plugin developer wrote the code.

    Some plugins give you the option to completely remove all options when you deactivate and remove. The default is to leave the options alone, so even if you delete the plugin files, their database entries are still present.

    There are reasons why this can be a good thing. There are reasons why it's not so good. WordPress has no official policy that I know of.
  • Richard60 · 2 months ago
    Thanks David, I use Wordpress exclusively for all my blogs, my server is Dreamhost and most of what you wrote about was over my head but I did forward the article to my webmaster
  • Dan Rippon · 2 months ago
    Thanks for the insight David, good to know the things that you should look out for.

    I realise I'm probably preaching to the converted, but have you experimented with running up a clone of your site on a fresh WP install elsewhere, or is it just the load that's killing it?

    Also, do you use or have you considered using a CDN? I think Yoast had some good things to say about them on his site recently.

    Cheers
  • David Risley · 2 months ago
    I don't think my needs are yet high enough for a CDN, but the thought has crossed my mind.
  • Antti Kokkonen · 2 months ago
    I have WP-Db-Backup plugin doing automatic backups and optimization, and I think it's helping clearing the overhead on the tables (my wp_options is not nearly that big). There's also spesific Optimize Db -plugin and WP-DbManager also does the trick I believe.
  • Steve · 2 months ago
    I have the wp-optimize plugin installed which clears up the options table everytime you optimize the database. I don't pay as much as you do for hosting but I don't have the traffic either.
  • John Paul · 2 months ago
    Great Post.. I have been deactivating or removing plugins this past week. Hoping to speed up my blogs load time.

    Looking into the Op Table now.

    Again nice helpful post. TY
  • Bruce Inouye · 2 months ago
    David,

    While we are talking about Wordpress using up a lot of space on servers here, I've noticed that WP saves all past versions of changes and modifications of posts and pages. Sometimes when I scroll down to the bottom of my post page after making a small edit, I see a very long line of past revisions. Is there a way I can delete all prior changes and modifications in that database? Seems like such a waste of space WP is using there.
  • David Risley · 2 months ago
    Yeah. first of all, you can turn that off by putting the following line of code into your wp-config.php file:

    define ('WP_POST_REVISIONS', 0);

    Secondly, I think the WP-Optimize plug-in has ability to remove all post revisions that already exist.
    http://wordpress.org/extend/plugins/wp-optimize/
  • Alberto · 2 months ago
    Dude you are scaring me with all this.

    What to do if it happens to me and i dont know all that mumbo jumbo?

    Who would I call? Sounds like Blogmageddon.

    Let your fearful followers know where to turn to if we shalt fall by the same fate?

    For real David, you gotta get back to us on this and post up somthing about who to turn to for quick damage control. That would make a good post. So keep us informed ok. Peace and good luck with it.
  • David Risley · 2 months ago
    There is no answer for this. Its just a matter of maintaining Wordpress and optimizing your server. It isn't something you're going to have a really hard time with unless you have a high-traffic blog. And, by that point, chances are you'll know some people in the field who you can turn to. Often, just posting on Twitter for help will get you many volunteers.
  • imegent78 · 2 months ago
    Waiting for another phenomenal post… It’d be nice to see some content worth reading (your blog is awesome!) since most of them are getting crappy these days.
  • Chris @ Driving Spirit · 2 months ago
    An extremely useful post and some insightful comments too. It's a shame more plugins don't include an option to remove themselves completely from the database. I'm off to look at my wp-options table now.
  • joebwharton · 2 months ago
    This is great information for all of us who use WP. Some of the plugins mentioned in the comments are on my list to check out. Thanks for the info.
  • Adam · 2 months ago
    Hey David,

    How do you access the options table to manually go in and delete entries? I am not sure how to do it.

    Thanks in advance!

    -Adam
  • Christian Russell · 1 month ago
    It's interesting that you wrote this article a little while ago; if I had read it when you actually posted it, the timing would have been perfect! Anyway, I do NOT have a high traffic site, but am always cool with finding a way to get better performance. I learned from a friend on twitter about this wp_options deal, and I found a ton of old entries and it sped page loads up noticeably. Pretty cool. You're absolutely right, when you get rid of a plugin...it's not gone!
  • iphone clone · 2 weeks ago
    This is great information for all of us who use WP,thanks for sharing