The MU forums have moved to WordPress.org

Options table clogged with _transient entries, problem? (5 posts)

  1. Bike
    Member
    Posted 14 years ago #

    Hi all,

    when browsing through teh database to find a solution to another problem, I noticed that the options table of my blig had about 6000 rown/entries.
    Besides the usable options and leftover options of past plugins and themes, there are about 5900+ option, starting/containing _transient, for example:
    "
    633290 0 _transient_timeout_rss_734066e4f1903696b5f576629c0... 1248574558 no
    Edit Delete 633291 0 _transient_rss_734066e4f1903696b5f576629c0d7deb O:9:"MagpieRSS":17:{s:6:"parser";i:0;s:12:"current... no
    Edit Delete 633292 0 _transient_timeout_rss_9a50fe858054067449160bcf5ae... 1248574558 no
    Edit Delete 633293 0 _transient_rss_9a50fe858054067449160bcf5aec1acb O:9:"MagpieRSS":17:{s:6:"parser";i:0;s:12:"current... no
    "

    - Is this a bug or a feature? How to get rid of it?
    - Will this huge options table affect performance?
    - Will it hurt to delete/clean the options table?

    Any hints or advice welcome,
    Cheers,
    Bike_

  2. andrea_r
    Moderator
    Posted 14 years ago #

    It's a feature, I guess. One I'm not fond of, but there you go. :)
    Yes, you can delete those rows right out of that table. backup, check 'em off carefully, hit the delete button.

  3. Bike
    Member
    Posted 14 years ago #

    Thanks Andrea

    I assume they will come back if it is a, hum, feature? Any idea what causes this and if it will impact performance if I let them be in peace?

    I do not want to check 6000 rows to see if there are any useful options to remain..
    Cheers, Bike

  4. andrea_r
    Moderator
    Posted 14 years ago #

    It's from pulling in the dashboard feeds for the WP planet & stuff.

  5. SteveAtty
    Member
    Posted 14 years ago #

    Its odd that they get left behind, I've just checked my options tables and although I've not got that many there do seem to be a lot of _transient options (and I get errors on mine because the cron keeps trying to insert new _transient_rewrite_rules).

    I'm starting to wonder if there is something not quite right with the _transient option handling.

About this Topic