WordPress.org

Forums

Google Analytics Dashboard
_transient_timeout_gad_cache_ (7 posts)

  1. flauius
    Member
    Posted 2 years 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 2 years ago #

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

  3. flauius
    Member
    Posted 2 years 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 2 years 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 2 years 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 2 years ago #

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

  7. fwchapman
    Member
    Posted 2 years 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

  • Google Analytics Dashboard
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic