[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…

    https://www.ads-software.com/extend/plugins/google-analytics-dashboard/

Viewing 3 replies - 1 through 3 (of 3 total)

  • Looks like I’m not the only one with this issue and Google Analytics Dashboard: https://www.staze.org/wordpress-_transient-buildup/

    Hmmm… just found another site, this time on a WP 3.2.1 install in Multi-site mode, where Google Analytics Dashboard is bloating the options table with transient entries.

    Can’t afford one site taking the whole network down with an inflated DB so I’ll be switching off Google Analytics Dashboard until this is resolved.

    Is there any chance the plugin author can fix this issue as well as automatically clear out all the rubbish it’s already created?

    Love the plugin – hate the swelling size of the DB though

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Plugin: Google Analytics Dashboard] Over 50MB of transient data in my wp_options table’ is closed to new replies.

Tags