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:
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…
- The topic ‘[Plugin: Google Analytics Dashboard] Over 50MB of transient data in my wp_options table’ is closed to new replies.