Yoast SEO Crazy Query Mysql

  • Resolved cras4202tw

    (@cras4202tw)


    6 years, 9 months ago

    WordPress Core: 4.9.5
    Plugin List: click me (gist)

    iF i activate Yoast SEO mysql go insane on CPU usage 100%
    Load average: 20.21 21 19.51 and website down!!
    When i deactivate Yoast SEO mysql will return to normal

    this site have over 100,000 media and 4000+ post
    Over 50,000 page views per day

    this is mysql-slow log: click me (gist)

    this is mysql SHOW PROCESSLIST:

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    We understand that Yoast SEO usage many queries on your site. Can you please disable the text link counter and analysis features from the Yoast SEO -> General -> Features (tab) to check whether this resolves the issue?

    If the issue persists, can you please elaborate more on what issues you are experiencing exactly?

    Thread Starter cras4202tw

    (@cras4202tw)

    In fact, even if I only have xml sitemap, the load is still very high.

    But closing (Security: no advanced settings for authors) reduces the load.

    Now I rely on Varnish to avoid excessive load on the web cache, but this load is still abnormal

    Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

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

    Don’t forget to include the URL to this conversation in your bug report.

    Closing this thread. Please open a Github issue and follow the progress of the report there.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Yoast SEO Crazy Query Mysql’ is closed to new replies.