Title: bradtm's Replies | WordPress.org

---

# bradtm

  [  ](https://wordpress.org/support/users/bradtm/)

 *   [Profile](https://wordpress.org/support/users/bradtm/)
 *   [Topics Started](https://wordpress.org/support/users/bradtm/topics/)
 *   [Replies Created](https://wordpress.org/support/users/bradtm/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/bradtm/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/bradtm/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/bradtm/engagements/)
 *   [Favorites](https://wordpress.org/support/users/bradtm/favorites/)

 Search replies:

## Forum Replies Created

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

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Account Engagement] Site times out from transient_keys and cache_keys](https://wordpress.org/support/topic/site-times-out-from-transient_keys-and-cache_keys/)
 *  Thread Starter [bradtm](https://wordpress.org/support/users/bradtm/)
 * (@bradtm)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/site-times-out-from-transient_keys-and-cache_keys/#post-11178190)
 * I have implemented these changes and will let you know if we see anything out
   of the ordinary. Good news is currently I’m not seeing the cache keys increase
   in size when visiting pages.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Account Engagement] Site times out from transient_keys and cache_keys](https://wordpress.org/support/topic/site-times-out-from-transient_keys-and-cache_keys/)
 *  Thread Starter [bradtm](https://wordpress.org/support/users/bradtm/)
 * (@bradtm)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/site-times-out-from-transient_keys-and-cache_keys/#post-11177488)
 * It fills up gradually over time. After about 30 minutes there were 500+ records
   in there. I assume it’s dependent on traffic.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Account Engagement] Site times out from transient_keys and cache_keys](https://wordpress.org/support/topic/site-times-out-from-transient_keys-and-cache_keys/)
 *  Thread Starter [bradtm](https://wordpress.org/support/users/bradtm/)
 * (@bradtm)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/site-times-out-from-transient_keys-and-cache_keys/#post-11177253)
 * Thank you Cliff for an update on this. What about the size of the column? We 
   see this value grow to 16+ MB and executing SQL Update commands that size which
   degrades performance, locks our database and eventually brings the server down.
 * What do these values in _pardot_cache_keys do? We are currently just deleting
   this row from the table every 5 minutes as over time it brings down our site.
 * Below is an example error we see from Pardot updating and sending a 400,000 item
   array to the database.
 * WordPress database error Deadlock found when trying to get lock; try restarting
   transaction for query UPDATE `wp_options` SET `option_value` = ‘a:483859:{i:0;
   s:7:\”account\”;i:1;s:7:\”account\”;i:2;s:7:\”account\”;i:3;s:7:\”account\”;i:
   4;s:7:\”account\”;i:5;s:7:\”account\”;i:6;s:7:\”account\”;i:7;s:7:\”account\”;
   i:8;s:7:\”account\”;i:9;s:7:\”account\”;i:10;s:7:\”account\”;i:11;s:7:\”account\”;
   i:12;s:7:\”account\”;i:13;s:7:\”
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Account Engagement] Site times out from transient_keys and cache_keys](https://wordpress.org/support/topic/site-times-out-from-transient_keys-and-cache_keys/)
 *  Thread Starter [bradtm](https://wordpress.org/support/users/bradtm/)
 * (@bradtm)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/site-times-out-from-transient_keys-and-cache_keys/#post-10970750)
 * Yeah, what fixed it for me was to rename the option value of ‘_pardot_cache_keys’
   to ‘_pardot_cache_keys_old’. Over time it would just create a new giant key and
   slow the site down. So setting it to ‘No’ fixed it perpetually.
 * This is definitely a big issue with the plugin being that it will slow your site
   down gradually until just bringing it down.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Account Engagement] Site times out from transient_keys and cache_keys](https://wordpress.org/support/topic/site-times-out-from-transient_keys-and-cache_keys/)
 *  Thread Starter [bradtm](https://wordpress.org/support/users/bradtm/)
 * (@bradtm)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/site-times-out-from-transient_keys-and-cache_keys/#post-10854089)
 * I believe I need to understand what _pardot_cache_keys and _pardot_transient_keys
   does. Right now the wp_option increase over time. I renamed the original ones
   this morning, and a new cache value has been created as expected. It’s slowly
   increasing, does this ever clear out or reset itself? What do these fields do?
 * Here’s a pic of the rows and sizes.
 * > [View post on imgur.com](https://imgur.com/Loxv33R)

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