Title: _transient_timeout_gad_cache_
Last modified: August 20, 2016

---

# _transient_timeout_gad_cache_

 *  [flauius](https://wordpress.org/support/users/flauius/)
 * (@flauius)
 * [13 years, 6 months ago](https://wordpress.org/support/topic/_transient_timeout_gad_cache_/)
 * 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/](http://www.staze.org/wordpress-_transient-buildup/)
   
   Many thanks.
 * [http://wordpress.org/extend/plugins/google-analytics-dashboard/](http://wordpress.org/extend/plugins/google-analytics-dashboard/)

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

 *  [sassyfrog](https://wordpress.org/support/users/sassyfrog/)
 * (@sassyfrog)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/_transient_timeout_gad_cache_/#post-3210727)
 * I have the same issue. Did you find an answer to this?
 *  Thread Starter [flauius](https://wordpress.org/support/users/flauius/)
 * (@flauius)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/_transient_timeout_gad_cache_/#post-3210728)
 * 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…
 *  [sassyfrog](https://wordpress.org/support/users/sassyfrog/)
 * (@sassyfrog)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/_transient_timeout_gad_cache_/#post-3210729)
 * 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.
 *  Thread Starter [flauius](https://wordpress.org/support/users/flauius/)
 * (@flauius)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/_transient_timeout_gad_cache_/#post-3210730)
 * 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…
 *  [sassyfrog](https://wordpress.org/support/users/sassyfrog/)
 * (@sassyfrog)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/_transient_timeout_gad_cache_/#post-3210731)
 * Worked like a charm! Thank you so much for your help. Much appreciated!
 *  [Fred Chapman](https://wordpress.org/support/users/fwchapman/)
 * (@fwchapman)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/_transient_timeout_gad_cache_/#post-3210732)
 * 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/](http://wordpress.org/extend/plugins/artiss-transient-cleaner/)
 * This will save you the trouble of manually deleting expired transients in phpMyAdmin.
 * Fred Chapman

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

The topic ‘_transient_timeout_gad_cache_’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/google-analytics-dashboard.svg)
 * [Google Analytics Dashboard](https://wordpress.org/plugins/google-analytics-dashboard/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/google-analytics-dashboard/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/google-analytics-dashboard/)
 * [Active Topics](https://wordpress.org/support/plugin/google-analytics-dashboard/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/google-analytics-dashboard/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/google-analytics-dashboard/reviews/)

## Tags

 * [transient](https://wordpress.org/support/topic-tag/transient/)

 * 6 replies
 * 3 participants
 * Last reply from: [Fred Chapman](https://wordpress.org/support/users/fwchapman/)
 * Last activity: [13 years, 1 month ago](https://wordpress.org/support/topic/_transient_timeout_gad_cache_/#post-3210732)
 * Status: not resolved