WordPress.org

Ready to get started?Download WordPress

Forums

wp_options table is bloated (14 posts)

  1. jhayrocas
    Member
    Posted 6 years ago #

    Hi everyone,

    I'm just curious, when browsing my blog's MySQL database using phpMyAdmin, I noticed that the 'wp_options' table has 4504 pages, 80% of it has the following 'option_name'

    rss_f07b6018d7bc77b2520b5ec4296f3e66_ts and so on.

    What is it exactly?

  2. Austin Matzko
    Member
    Posted 6 years ago #

    That is a cached rss lookup. Normally, you wouldn't see more than a handful of those, as by default WordPress just caches the rss feeds you see on the Dashboard, such as the blogs that link to you, WordPress news and development feeds, etc.

    So either something is going seriously wrong with that, and the caches aren't being deleted, or you have some sort of plugin that is caching many feeds.

  3. Samuel Wood (Otto)
    Tech Ninja
    Posted 6 years ago #

    Note that it is perfectly safe to delete those rows. WordPress will recache them when/if it needs them.

  4. jhayrocas
    Member
    Posted 6 years ago #

    Thanks guys. I'm going to delete them after posting this reply.

    How do I configure WordPress to automatically delete those cached rss lookups? Or what plugin could possibly be involved?

    I have a feeling CommentLuv is the culprit as it displays each commenter's latest post via RSS and it's an optional feature.

  5. Austin Matzko
    Member
    Posted 6 years ago #

    If you take a look at the option_value field, you should be able to figure out where it's coming from.

  6. jhayrocas
    Member
    Posted 6 years ago #

    I'm no MySQL expert but it has something to do with the php RSS parser, magpie rss. Here's what's inside the option_value field:

    O:9:"magpierss":19:{s:6:"parser";i:0;s:12:"current_item";a:0:{}s:5:"items";a:0:{}s:7:"channel";a:0:{}s:9:"textinput";a:0:{}s:5:"image";a:0:{}s:9:"feed_type";N;s:12:"feed_version";N;s:5:"stack";a:0:{}s:9:"inchannel";b:0;s:6:"initem";b:0;s:9:"incontent";b:0;s:11:"intextinput";b:0;s:7:"inimage";b:0;s:13:"current_field";s:0:"";s:17:"current_namespace";b:0;s:19:"_CONTENT_CONSTRUCTS";a:6:{i:0;s:7:"content";i:1;s:7:"summary";i:2;s:4:"info";i:3;s:5:"title";i:4;s:7:"tagline";i:5;s:9:"copyright";}s:13:"last_modified";s:31:"Fri, 19 Oct 2007 17:00:12 GMT
    ";s:4:"etag";s:26:""1ab07e3-143dd-4718e29c"
    ";}

    So could it be caused by CommentLuv plugin? Or something else?

  7. Samuel Wood (Otto)
    Tech Ninja
    Posted 6 years ago #

    How do I configure WordPress to automatically delete those cached rss lookups?

    You kinda don't. There's no code in WordPress to do that. I'll put it in the bug tracker as an enhancement, maybe somebody will figure out a way.

    Edit: Done. http://trac.wordpress.org/ticket/6897

  8. jhayrocas
    Member
    Posted 6 years ago #

    Oh...so in the meantime magpieRSS will continue to bloat my database with old and unused RSS feeds?

    What if I disable the feeds in my dashboard for a while? Because as of this writing, I'm still cleaning up my bloated wp_options table. T.T

    Thanks for opening a ticket in the bug tracker. I'll be keeping an eye on it.

  9. Samuel Wood (Otto)
    Tech Ninja
    Posted 6 years ago #

    Oh...so in the meantime magpieRSS will continue to bloat my database with old and unused RSS feeds?

    No, it only caches a feed when it's told to go out and get it. If you're not using it, then it won't get it and it won't cache it.

    That "f07b6018d7bc77b2520b5ec4296f3e66" is a hash of the feed URL. When it goes out and gets it the next time, it just replaces the existing one, it doesn't add a new one.

  10. jhayrocas
    Member
    Posted 6 years ago #

    Ok, I understand now. I've decided to disable the Planet WordPress feed in my dashboard and used Google Reader for it instead.

    So now I only have the WordPress development blog's feed displayed in my dashboard. If my wp_options table still gets bloated with cached RSS then something else is seriously wrong with my blog.

    By the way, I have two RSS widgets on my blog's front page, these also contribute to the cached RSS feeds in my database right?

    Thank you very, very much. :D

  11. Sapphire
    Member
    Posted 6 years ago #

    There's a plugin called Clean Options that'll help you clean those out.

    http://www.mittineague.com/dev/co.php

    I think you can also just go to your database in PhpMyAdmin, click "search", use "rss_" as your search term, select "wp-options" in the box below, and "delete" all the entries that come up. If you want to double check, you can browse them before deleting.

  12. raufaser
    Member
    Posted 5 years ago #

    http://wordpress.org/extend/plugins/wp-options-manager/

    Another solution for your problem.

    Have fun!

    Marc

  13. osowande
    Member
    Posted 5 years ago #

    Hello,

    My wp_options table is also bloated.

    so I can empty this table without affecting the blog?

    Thanks.

  14. Alwyn Botha
    Member
    Posted 5 years ago #

    >>>My wp_options table is also bloated.

    >>>so I can empty this table without affecting the blog?

    No do not do that - that table contains all the options for WP and all your plugins to work.

    >>>Note that it is perfectly safe to delete those rows. WordPress will recache them when/if it needs them.

    Otto meant there ONLY the specific RSS options filosofo referred to.

Topic Closed

This topic has been closed to new replies.

About this Topic