Too many wc transients created in DB

Hi Jackie, my website crushed several times also.

Plugin to use: Wp-Optimize

There is an option to automatically clean transients every, day, week, etc

At this moment, I had to modify the plugin to clean the transients every hour.

Good luck

@gustavogravina Thanks. I did install a plugin two days ago that told me I didn’t have any transient files. It must have lied. ?? So as soon as I can get on my site, I want to get a different one.

But WooCommerce is such a popular shopping cart — how can it be having this problem???

It’s being worked on – keep up to date with the development of 2.5 on https://woocommerce.wordpress.com/

Thanks, Mike. So much of that is over my head, but it looks like a fix will be available in January.

I might want to rethink my plan for doing a Cyber Monday sale.

@jackie-tcs You could try the optimise plugin as suggested, and I’d suggest perhaps trying https://github.com/kloon/woocommerce-large-sessions as well so customer carts are not stored in your options able. That may improve performance in your case.

Mike, is that a plugin?

I’m still waiting for Godaddy’s tech to get my site back so I can access it.

Here’s the thing: I’ve just recently started selling online. I’ve had ONE! sale this week, it was yesterday. I’m terrified to think what will happen when my marketing starts working.

Yes it’s a plugin – thats one of the things we’re bundling in core in 2.5.

If your site is currently low-traffic I’m not sure why your transients would go out of control though.. they only cache things like product queries.

That’s a good question. My site is currently very low-traffic. I’m working on changing that. ?? But I can’t even begin fixing it until I can get access to it. And I’m still waiting on Godaddy for that.

Again, thanks for your help. Should I do more than one plugin that deals with this issue or only one at a time?

A plea for help: The Godaddy guys tried to delete the transient data and couldn’t. They said I have over 17K records and their queries kept timing out.

My site is down.

Can anyone tell me how to do this? Or do it for me? I’ll pay for the help.

thanks.

GoDaddy have direct access to your database – are you sure they are talking about transients here? i.e. rows in the wp_options table prepended with wp_transient_ Why are they not clearing them in batches if they are indeed the problem? Sounds very odd..

they said they couldn’t clear them in batches. And I have no idea what I’m looking at.

If your site is down due to the options table, why can I see it? I think there may be some confusion here – either that or the tech you’re dealing with needs to escalate the issue because with direct database access they can do much more than you could, if it is indeed due to transients in your database (not files as you said).

I redirected my main site to a different site that I have, and created that page that says the site is down. Before I did that, nothing was coming up.

they’re saying it’s not their issue and I have to figure it out.

For awhile I was deleting the transients myself. It’s time consuming, but better than having your site down. To delete them go to
MANAGE YOUR HOSTING and click on SETTINGS
Then click on DATA BASE
Then click on the link at “phpMyAdmin Url”
That takes you to a Log in page where it asks for your user name and password.
When I do that I go to a page with two items on the left side. One says information_schema. Ignore that one.
The other is my username. Click on that one.
That brings up a long list of stuff on the left. Click on the one that says OPTIONS
Go to BROWSE
That takes you to a table that includes your Transients. You DO NOT want to delete anything that’s not a transient!!
There are two boxes: SHOW # of ROWS and STARTING AFTER # of cells.
I put in 500 Rows Starting at Cell 1,000
That brought up a page of 500 transients.
Scroll down to the bottom and click “CHECK ALL”
Then click the Red X. That then takes you to a page that asks if you really want to delete them all. Click YES.
It takes a few minutes to delete them all.
Once they’re deleted, repeat the last series of steps.
Hope this helps.

You mean after they couldn’t work it out ??

Put:

define( 'WP_DEBUG', true );

In your wp-config.php file and view the site. See what error if any you get, because they may be totally off base with the transient idea.