3

I just noticed 55.000 entries(!) in my wp_options table. I had not been there for a while.

So I ran:

delete from `wp_options` where `option_name` like '_transient_timeout_rss%'
delete from `wp_options` where `option_name` like '_transient_rss_%'

And... it is now back to 645 entries...

How can I have these older RSS entries removed automatically since transient seems to be eternal.

Could It be that on my webhost cron is not working?

Improve this question

2 Answers 2

Reset to default
4

Yep, this does seem like a cron issue.

Core Control plugin is good to diagnose cron tasks (among other things).

I am still unsure what is the reason of you getting overrun with feed transients. However I had written some code that might help with automatic cleanup.

Improve this answer
4
  • I tried scheduling a post and well... it was actually posted grmbl so it looks like cron works but the rss feeds are never ever removed. maybe I can cron the 2 sql lines to run once every week GRIN
    – edelwater
    Dec 21, 2010 at 9:12
  • @edelwater should work... it places its page in Tools
    – Rarst
    Dec 21, 2010 at 9:44
  • but uhm... its not part of wp_scheduled_delete ?
    – edelwater
    Dec 21, 2010 at 9:47
  • Actually I am no longer sure it is linked to cron... Transients are deleted if they are outdated on access and class that handles feed transients has unlink() method as well...
    – Rarst
    Dec 21, 2010 at 9:56
3

The entries life for different time. You can run a sql for delete all: DELETE FROMwp_optionsWHEREoption_nameLIKE ('_transient%_feed_%')

THe easiest wy for run a sql direct on the database is the plugin Adminer inside the WP Backend. More you can read on this post about delete the transient-cache of feeds.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.