[Plugin: Google Analytics Dashboard] Over 50MB of transient data in my wp_options table

Hi,

Perfectly happy with this plugin, showing me valuable info on my dashboard and posts pages, I have been using it for a while on one of my smaller websites. This site is hosted at a budget provider which does not allow a database size of over 50MB. Plenty big for a small WordPress site, one would expect.

Imagine my surprise when I discover the DB size silently went up to almost 60 MB, effectively crippling the website as DB access is now blocked.

Searching the DB, I find the wp_options table is larger than a whopping 55 MB instead of being its usual 1 or 2 MB. In it, I find endless entries of this kind:

_transient_timeout_gad_cache_1_b0d1c243ff961d92369...
_transient_gad_cache_1_b0d1c24...

I’ve tracked these entries back to simplefilecache.php and as far as I can tell, the timeout is 600 (10 minutes) so I see no reason for there being that many entries in the DB. What can be the cause of expired transient entries not being purged?

I cleared all transient entries from the table with

DELETE FROM 'wp_options' WHERE 'option_name' LIKE ('_transient_%')

but I’d really prefer not to have to come back each time to do this manually…

http://wordpress.org/extend/plugins/google-analytics-dashboard/