WordPress.org

Ready to get started?Download WordPress

Forums

Google Analytics Dashboard
_transient_timeout_gad_cache_ (7 posts)

  1. flauius
    Member
    Posted 1 year ago #

    Hi,

    I have a lot of entries on the wp_options table for _transient_timeout_gad_cache_

    From what I read on the web, these are cache from Google Analytics Dashboard, but, despite the fact they should be deleted after a period of time, they stay there forever.

    I suppose some slowness in my server is because of these db that grows with no sense (50MB for a single blog).

    Do you have any easy fix for this?

    This was one of the articles that helped me to find the issue: http://www.staze.org/wordpress-_transient-buildup/
    Many thanks.

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

  2. sassyfrog
    Member
    Posted 1 year ago #

    I have the same issue. Did you find an answer to this?

  3. flauius
    Member
    Posted 1 year ago #

    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...

  4. sassyfrog
    Member
    Posted 1 year ago #

    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.

  5. flauius
    Member
    Posted 1 year ago #

    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...

  6. sassyfrog
    Member
    Posted 1 year ago #

    Worked like a charm! Thank you so much for your help. Much appreciated!

  7. fwchapman
    Member
    Posted 12 months ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic