WordPress.org

Ready to get started?Download WordPress

Forums

Google Analytics Dashboard
Over 50MB of transient data in my wp_options table (4 posts)

  1. RavanH
    Member
    Posted 2 years ago #

    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/

  2. RavanH
    Member
    Posted 2 years ago #

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

  3. RavanH
    Member
    Posted 2 years ago #

    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.

  4. Martin
    Member
    Posted 2 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic