Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

When transient version increases (to clear cache) clear old transients #8131

Closed
mikejolley opened this Issue May 8, 2015 · 12 comments

Comments

Projects
None yet
8 participants
@sjeden

This comment has been minimized.

Copy link
Contributor

sjeden commented May 14, 2015

+1 - 140k rows in my options table.

@mikejolley mikejolley modified the milestone: 2.4 Helpful Hedgehog May 19, 2015

@sjeden

This comment has been minimized.

Copy link
Contributor

sjeden commented May 19, 2015

Showing rows 0 - 24 (448011 total, Query took 0.0007 sec)
SELECT * FROM '***_options`

@sjeden

This comment has been minimized.

Copy link
Contributor

sjeden commented May 22, 2015

This has risen to 466k after clearing all session data via the tools page it has now dropped to 360k

@sjeden

This comment has been minimized.

Copy link
Contributor

sjeden commented Jun 1, 2015

Just updated to 2.3.10 and it removed 30k lines in my options table -after this i cleared all shop transients from the tools page -

I still have in excess of 390k records.

@mikejolley

This comment has been minimized.

Copy link
Member Author

mikejolley commented Jun 1, 2015

The records can include real transients and customer sessions. We need those ;)

@nielsvr

This comment has been minimized.

Copy link

nielsvr commented Sep 1, 2015

It seems to got worse lately. I even got sites where I have to clean the transients, because the site is getting to slow and the database way to big causing timeouts. I'm not against transients, but this is too much if it causes serious loading issues. I got around 3 or 4 shops under maintenance which have the same issue regular.

Maybe a filter for limiting the transient usage? If it's causing more issues then disabled, I'd rather have the choice.

@mdmoore

This comment has been minimized.

Copy link
Member

mdmoore commented Sep 4, 2015

I'm having issues with this as well. Category pages are taking anywhere between 5 - 20 seconds to insert transients on every page load. I'm using WordPress 4.3 and WooCommerce 2.4.6 with around 420 products.

Clearing transients does seem to help but they continue to build up. Is there a way around this?

@CyberCr33p

This comment has been minimized.

Copy link

CyberCr33p commented Sep 14, 2015

How do you clear transients ?

@mdmoore

This comment has been minimized.

Copy link
Member

mdmoore commented Sep 14, 2015

Go to WooCommerce->System Status->Tools and click Clear transients.

@DaDre

This comment has been minimized.

Copy link

DaDre commented Sep 30, 2015

Clearing transients every day is not a viable solution. We have a high traffic site that fills up with over 250k transients per day that are not clearing automatically, which also leads to carts not being emptied after session is over, customers are coming back weeks later and are able to checkout with a cart from 2 weeks ago where products could be discontinued, or not in stock, causing backorders.

@ryan-boder

This comment has been minimized.

Copy link

ryan-boder commented Nov 16, 2015

Our site has gone down several times over the past few months and we've traced it back to this issue. WooCommerce is creating thousands of transients per day called wc_average_rating and wc_rating_count. Eventually it starts to slow the site down and when it hits a certain threshold the site just crashes.

I can set up a daily job to delete these transients as a temporary solution but is this problem being fixed? Surely this can't be considered correct behaviour. I'm on WooCommerce 2.4.10.

@claudiosanches

This comment has been minimized.

@woocommerce woocommerce locked and limited conversation to collaborators Nov 16, 2015

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
You can’t perform that action at this time.