|
Ken Reinstein
|
July 22, 2014 at 12:46 pm
On our site the wp-options table seems to have 5 million previous entries and 200,000 current entries from event espresso . . . I don’t understand why this would be. Why are there so many?
4115938
_transient_ee_ssn_1tokjh4hhg690cgcdqtcgrolm5
s:514:”a:7:{s:2:”id”;s:26:”1tokjh4hhg690cgcdqtcgro…
no
Edit
Inline Edit
Copy
Delete
4115939
_transient_timeout_ee_ssn_cm5s0m22ug5al0s6mnhlsckh…
1406219166
I’m guessing that transient_ee_ssn comes from EventEspresso – is that right?
We’re on EE 4.2.8.p
Wordpress 3.9.1
The registration pages are here: http://www.sunhealth.org/community-education-events/
Thanks!
~liz
|
|
Dean
|
July 22, 2014 at 11:42 pm
Hi Liz,
That is indeed Event Espresso, though the number seem oddly high.
Can I ask, do you get a large number of visitors to your site and/or registrants for your events?
|
|
Josh
|
July 23, 2014 at 8:51 am
Hi Liz,
We might end up ditching the WP transient API and coming up with an alternative solution for what EE uses transients for. Or, we’ll build in a more aggressive garbage collection for expired transients. In theory the expired transients should disappear after a little while, but we’re finding that this doesn’t happen.
In the meantime, we recommend installing this plugin:
http://wordpress.org/plugins/delete-expired-transients/
It does exactly what its name implies, it deletes expired transients.
|
|
Scott Zuckerman
|
July 30, 2014 at 12:35 pm
I am facing the same issue… my DB dump size increased to more than 300 MB. Please provide me fix asap !!
|
|
Josh
|
July 30, 2014 at 12:37 pm
Hi Scott,
Have you tried installing this plugin:
http://wordpress.org/plugins/delete-expired-transients/
|
|
Scott Zuckerman
|
August 1, 2014 at 10:18 pm
Yes, I have tried using that plugin, but once it clears all the expired transients, when I login through phpmyadmin to check, most of those are still being inserted into DB again.
|
|
Dean
|
August 1, 2014 at 10:51 pm
Hi Scott,
Thanks for the feedback. The transients will be re-inserted again as the plugin does use the. However we are working on a more aggressive trashing system to keep the numbers much lower than they are currently.
|
