I have the same issue. Did you find an answer to this?
Hi sassyfrog…
I did not… So, deactivated the plugin and deleted the db entries manually. It solved the serve slowness…
It was said to me that there is a way to set the db to delete this entries periodically… but I have no programing skills…
Thanks! I think I will do the same. Did you use a mysql query to delete the entries? I have no sql language skills and a lot of entries to delete.
Yes, I did… Here is what I tried:
First of all, backup your db… use a plugin or export the database from your phpMyAdmin.
Log into your phpMyAdmin, select the db, then the SQL tab. Use these lines to delete the transients:
DELETE FROM wp_options WHERE option_name LIKE ('_transient%_feed_%');
DELETE FROM wp_options WHERE option_name LIKE ('_transient_timeout%');
DELETE FROM wp_options WHERE option_name LIKE ('_transient_%cache%');
It is a good time to delete post revisions too, for that, use this:
DELETE FROM wp_posts WHERE post_type = "revision";
And… don’t forget the backup…
Alternatively, you can use WP DBManager… It is a great plugin that will allow you do all the job from your WP Dashboard…
Hope it will be useful…
Worked like a charm! Thank you so much for your help. Much appreciated!
I just discovered this problem in a new client’s database, which contained 15 MB of expired transients. I found a wonderful plugin that deletes expired transients upon activation and automatically cleans up the database every day:
http://wordpress.org/extend/plugins/artiss-transient-cleaner/
This will save you the trouble of manually deleting expired transients in phpMyAdmin.
Fred Chapman
