Support » Plugin: Yoast SEO » Yoast SEO Crazy Query Mysql

  • Resolved cras4202tw


    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


    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


    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


    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 You will need an account to create a new issue. If this is your first bug report, please check out:

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

    Plugin Support Jerlyn


    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.