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?

 Inline Edit

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:



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?


  • 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:

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 !!


  • Support Staff

July 30, 2014 at 12:37 pm

Hi Scott,

Have you tried installing this plugin:

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.


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, 11 months ago ago

Topic Tags



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