Yoast DB queries slowing down site

  • Resolved mishapchen

    (@mishapchen)


    3 years, 10 months ago

    Our website became extremely slow. After days, if not weeks, of research we’ve found that Yoast is slowing down the website because Yoast is making thousands (12.000+) DB requests.

    Yoast is inserting thousands of entries in the “wp_yoast_indexable” and “wp_yoast_indexable_hierarchy” table. These queries look like:
    https://ibb.co/Hhw66nX

    At the same time there are a lot of errors because some of the queries try to insert an empty value into a DB column where an integer is expected:
    https://ibb.co/61wV5jB

    When “Reset Indexables tables & migrations” is run in the “Yoast Helper” plugin the errors are fixed. However, when using the website the errors and enormous DD queries come back. When running the “SEO Data Optimization” the problem is accelerated.

    How can we (or you) fix this? We cannot have a website which needs 40 seconds for running Yoast DB queries!

    Also; we are running the latest version of Yoast and are about to update WordPress.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    Hello,

    We are sorry about the many database queries. First, we will like to clarify that resetting the indexables table and migrations will re-prompt you to re-run the SEO data optimization tool.

    To troubleshoot, can you please disable the ‘Text link counter’ feature in SEO > General > Features? Does this improve the overall performance of the database?

    Thread Starter mishapchen

    (@mishapchen)

    Hi,
    I’ve disabled the “text link counter” two days ago. Now the frontpage of the website is not loading at all since too many queries are being made. Earlier today my colleague managed to load the frontpage and told me that there were over 2000 query errors, all originating from Yoast.

    I really suspect that the problem is at your side since the query in the code is trying to input an empty value in a DB field where an integer is expected.

    Plugin Support devnihil

    (@devnihil)

    @mishapchen We’re sorry to hear that you’re still experiencing these issue.

    Can you please let us know whether this is a very large site?

    For the indexables features, for sites with more than 10,000 posts, instead of using the ‘Start SEO data optimization’ button, we’d advise using the following WP-CLI command to do the indexation on the server:
    ??
    wp yoast index --reindex

    ??You can read more about this here: https://developer.yoast.com/features/wp-cli/reindex-indexables/`

    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 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Yoast DB queries slowing down site’ is closed to new replies.