Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

up vote 4 down vote accepted

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.

share|improve this answer
    
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 '10 at 9:12
    
@edelwater should work... it places its page in Tools –  Rarst Dec 21 '10 at 9:44
    
but uhm... its not part of wp_scheduled_delete ? –  edelwater Dec 21 '10 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 '10 at 9:56

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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