bradtm
Forum Replies Created
-
Forum: Plugins
In reply to: [Account Engagement] Site times out from transient_keys and cache_keysI 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
In reply to: [Account Engagement] Site times out from transient_keys and cache_keysIt fills up gradually over time. After about 30 minutes there were 500+ records in there. I assume it’s dependent on traffic.
Forum: Plugins
In reply to: [Account Engagement] Site times out from transient_keys and cache_keysThank 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_optionsSEToption_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
In reply to: [Account Engagement] Site times out from transient_keys and cache_keysYeah, 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
In reply to: [Account Engagement] Site times out from transient_keys and cache_keysI 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.