Yoast SEO causing server load to go up

  • Resolved thefriendlancer

    (@thefriendlancer)


    3 years, 11 months ago

    Hi Support,

    We are investigating a load issue where every time we update a WordPress blog comment (e.g. flagging it as spam), it causes our server load to extremely high to a point it becomes inaccessible.

    We checked the MySQL logs and we identified 2 possible culprits.
    One is Autoptmize but we have already ruled that out after further tests.

    We are also looking into Yoast SEO as whenever we do a comments update, it fires a hugh chunk of SQL update below:

    UPDATE wp_usermeta SET meta_value = ‘a:2:{i:0;a:2:{s:7:\”message\”;O:61:\”Yoast\\WP\\SEO\\Presenters\\Admin\\Indexing_Notification_Presenter\”:3:{s:18:\”\0*\0total_unindexed\”;i:19806;s:9:\”\0*\0reason\”;s:13:\”first_install\”;s:20:\”\0*\0short_link_helper\”;O:38:\”Yoast\\WP\\SEO\\Helpers\\Short_Link_Helper\”:2:{s:17:\”\0*\0options_helper\”;O:35:\”Yoast\\WP\\SEO\\Helpers\\Options_Helper\”:0:{}s:17:\”\0*\0product_helper\”;O:35:\”Yoast\\WP\\SEO\\Helpers\\Product_Helper\”:0:{}}}s:7: …………

    Just wondering why is this always firing and can this be a cause of consuming huge server resource?

    Thanks!

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

  • Hi @thefriendlancer!

    We are not sure why that is happening. We would like some more information.

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

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

    3. Can you confirm you are using WordPress 5.7? 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/.

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

    Plugin Support devnihil

    (@devnihil)

    We are going ahead and marking this issue as resolved due to inactivity. If you require any further assistance please create a new issue.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Yoast SEO causing server load to go up’ is closed to new replies.