Latest Update Causes Server Overload

I also have the same problem.
My WordPress dashboard home page loads over a minute.

In the Query Monitor plugin i can see that this query is very slow:

SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (SELECT object_id
FROM wp_yoast_indexable
WHERE object_type = 'term')
AND taxonomy IN ('category', 'post_tag', 'post_format')

called by Yoast\W\S\A\I\Indexable_Term_Indexation_Action->get_total_unindexed()

I have 30,000 posts and 10,000 tags in the database.

• This reply was modified 4 years, 6 months ago by Rafa? Ca?ka.
• This reply was modified 4 years, 6 months ago by Rafa? Ca?ka.

I can confirm that we are seeing the same issue. Query Monitor reports the exact same slow query adding several seconds to each request

Hello @shallym

Can you confirm this is occurring with the latest version of v14.2 of Yoast SEO for WordPress? If you were to install the Query Monitor plugin, could you confirm you are also getting the same slow query from the wp yoast indexable query?

@pipdig @rafaucau

We apologize for any issues. Just to confirm, this is also with v14.2 of the Yoast SEO for WordPress plugin? And if you temporarily deactivate the Yoast SEO plugin, does the site slowdown then resolve?

@mikes41720 yes v14.2 and deactivating Yoast fixes the issue.

cc @vincepettit as it seems to be a same issue as https://www.ads-software.com/support/topic/increased-memory-usage-after-latest-update/

@pipdig also, just to clarify, did you already perform and complete the Indexables process and that it’s showing as completed under your WP admin dashboard > SEO (sidebar) > Tools > SEO data?

@mikes41720
After I create this post, I tried deleting Yoast and installing it back.
I tried for some time but still the same. Then I deactivate the plugin since I am about to go to sleep last night.
And upon reading your reply in the noon, i activate Yoast (at that time server load around 0.3). I wait for a while and the server load is fine for me and no high queries from mysql.
Then I leave it activated and for the past 15 minutes the load average is 1.08.
I am still monitoring

I installed Query Monitor, in the beginning there is no Yoast slow query.
But Just now I do see slow query ( https://pasteboard.co/JaCi1c1.jpg ).

@pipdig also, just to clarify, did you already perform and complete the Indexables process and that it’s showing as completed under your WP admin dashboard > SEO (sidebar) > Tools > SEO data?

@mikes41720 that’s correct, it was indexed some time ago – https://i.imgur.com/fA6t9wF.png

@mikes41720
For me, this query takes about 80 seconds on every request. So this is a big problem for me.

Problems began to appear after some time since update v14.2. They didn’t appear immediately.
Everything is indexed.

When I run this query in PHPMyAdmin, it’s also terribly slow and returns
COUNT(term_id) = 0

• This reply was modified 4 years, 6 months ago by Rafa? Ca?ka.

@pipdig @rafaucau @shallym

We are not sure why that is happening as it may be a bug. We would like some more information.

1. Can you confirm you are using WordPress 5.4.1? You can check by clicking on the W in the top left and selecting About. If you need to update, please check with your host provider.?Please know that if you are using an older version of WordPress Core you may experience unexpected behavior with Yoast.?This guide explains more:?https://yoast.com/why-we-dont-support-old-wordpress-versions/.

2. Are all your non-Yoast plugins and themes also updated?

3. We had another recent release. Can you confirm you are using the most recent Yoast SEO, v14.2? If you update, does the issue resolve?

IF the issue continues when all are updated then we ask that you please try the following as that sounds like a plugin or theme conflict.

Please Check for conflicts. Please deactivate all your non Yoast plugins and switch to a standard theme like 2019. Does the issue continue?

If the issue stops, please re-enable each plugin until you find the plugin or theme which is conflicting with Yoast. Once identified we ask that you please create a new GitHub issue?for our developers. Please report the issue to a third party developer as well.

Hi @pcosta88,

I’ve deactivated all plugins and activated the Twenty Nineteen theme. The issue remains when Yoast is the only active plugin.

I have manually updated to the latest version

Using WordPress 5.4.1

Hope that helps. We’ve had to remove Yoast as it was choking up the Litespeed server.

@pipdig

Thank you for doing that check. Based on the information you provided, we expect this to be a bug. We’re actively using the bug tracking on our GitHub repository so your best next step would be to create a new issue for our developers at https://github.com/Yoast/wordpress-seo/issues/new. You will need an account to create a new issue. If this is your first bug report, please check out: https://kb.yoast.com/kb/how-to-write-a-good-bug-report/.

@pcosta88
I also have a Litespeed server. Maybe the problem with Yoast SEO only occurs on this server?

Wordpress 5.4.1

• This reply was modified 4 years, 6 months ago by Rafa? Ca?ka.
• This reply was modified 4 years, 6 months ago by Rafa? Ca?ka.

Hi,

@rafaucau We are not sure at this point we can only recommend making a bug report here: https://github.com/Yoast/wordpress-seo/issues/new. The repository is monitored by our team so you can expect a reply. You will need an account to create a new issue. If this is your first bug report, please check out: https://kb.yoast.com/kb/how-to-write-a-good-bug-report/.

Ok, I created an issue: https://github.com/Yoast/wordpress-seo/issues/15341

• This reply was modified 4 years, 6 months ago by Rafa? Ca?ka.
• This reply was modified 4 years, 6 months ago by Rafa? Ca?ka.

@rafaucau Thank you for submitting a bug report. For anyone who’s also experiencing the issue, please do feel free to make a comment on the relevant bug report so our development team can look into this further for you.