Support

Home Forums Event Espresso Premium Event Espresso creates 5 million entries in the wp-options table

Event Espresso creates 5 million entries in the wp-options table

Posted: July 22, 2014 at 12:46 pm


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

  • Support Staff

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

  • Support Staff

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.

The support post ‘Event Espresso creates 5 million entries in the wp-options table’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  Dean 5 years, 4 months ago ago

Topic Tags

Tagged: 

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!