wp_yoast_indexable

  • Resolved Tim Dueck

    (@duecktimothy)


    4 years, 6 months ago

    Hey, I’m having an issue. My website is receiving a spike every hour, and looking at the statistics on new relic. It appears my 404 pages are what’s causing the spike, this is the MySQL query that’s running. Just wondering why this might be?

    MySQL wp_yoast_indexable update

    I’ve also noticed that Query Monitor has shown slow down as the following.

    SELECT *
FROM <code>wp_yoast_indexable</code>
WHERE <code>object_id</code> = '1'
AND <code>object_type</code> = 'post'
LIMIT 1

    with the caller of Yoast\W\L\ORM::_execute()

Viewing 9 replies - 1 through 9 (of 9 total)

  • Hi,

    I would just like to know, if it’s in version 14.1? (Cause, if so.. I guess, I should wait a bit, with hitting the “Update button”…)

    Thread Starter Tim Dueck

    (@duecktimothy)

    It is, however I don’t know if it’s necessarily an issue with Yoast. I’m trying to figure that part out.

    Plugin Support marcanor

    (@marcanor)

    Hi @duecktimothy,

    Thanks for the detailed report! We apologize for any issues this is causing on your site.

    Can you please confirm if you’ve performed the indexing process on your site? You can check by going to SEO > Tools and verify if the if the “SEO Data” entry has a green check and says “Good job! You’ve sped up your site.”

    Please let us know if you have any further information.

    Thread Starter Tim Dueck

    (@duecktimothy)

    @marcanor Hey, It says “Great, your site has been optimized!”

    Not sure what else I could look at. My only thought is that if I’m getting lot’s of 404 hits then the plugin keeps checking those pages whether they should be indexed or not?

    Plugin Support Maybellyne

    (@maybellyne)

    Hello @duecktimothy,

    Can you please confirm if your website is still receiving a spike every hour, even after completing the indexation?

    We look forward to hearing from you.

    Thread Starter Tim Dueck

    (@duecktimothy)

    @maybellyne Yes it is still receiving a spike every hour even after the indexation.

    @duecktimothy

    We would not expect that to happen. We are happy to investigate this issue but we would like some more information.

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

    2. 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/.

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

    4. Can you confirm your server has all the right requirements? ?If you are not sure, speak to your host provider.?They may need to increase the PHP memory.?This guide explains more:?https://kb.yoast.com/kb/plugin-requirements/.

    Thread Starter Tim Dueck

    (@duecktimothy)

    @pcosta88

    1. Yes I am on latest release

    2. Yes I am using 5.4.1

    3. All my plugins are updated

    4. I’m running on a Cloudways Digital Ocean server with 4gb ram, 2 core processor, 4tb bandwidth.

    I should note, like I mentioned I’m not totally convinced this is an issue with Yoast, I’m wondering if my site is doing some kind of work in the background every hour and Yoast just happens to be running at that time which flags yoast as the issue but there might be something else occurring.

    Thread Starter Tim Dueck

    (@duecktimothy)

    I just wanted to let you that I don’t believe it’s an issue directly with Yoast, I think I’m just receiving lots of bot traffic to URLs that don’t exist any more every hour and it’s causing my server to lag.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘wp_yoast_indexable’ is closed to new replies.