yoast seo woo products high cpu usage

  • Resolved glamurnapani

    (@glamurnapani)


    7 years ago

    high hosting cpu usage

    after yoast seo update cpu usage when I click woo–products–all is above 90-95%
    and loading time (by query monitor) is above 8 seconds.
    also query monitor detects duplicate queries

    SELECT ID
    FROM wpx1_posts AS posts
    LEFT JOIN wpx1_yoast_seo_meta AS yoast_meta
    ON yoast_meta.object_id = posts.ID
    WHERE posts.post_status = “publish”
    AND posts.post_type IN ( “post”, “page”, “product” )
    AND yoast_meta.internal_link_count IS NULL
    LIMIT 1

    27 WPSEO_Link_Query::has_unprocessed_posts()
    27 calls
    Plugin: wordpress-seo
    27 calls
    get_column_headers()
    1 call
    WP_List_Table->get_default_primary_column_name()
    26 calls

    its just 20 records (products) per page.

    with a 100 products per page (woo–products-all) cpu usage is above 97% loading time about 40 seconds and over a 100 duplicate queries

    SELECT ID
    FROM wpx1_posts AS posts
    LEFT JOIN wpx1_yoast_seo_meta AS yoast_meta
    ON yoast_meta.object_id = posts.ID
    WHERE posts.post_status = “publish”
    AND posts.post_type IN ( “post”, “page”, “product” )
    AND yoast_meta.internal_link_count IS NULL
    LIMIT 1
    107 WPSEO_Link_Query::has_unprocessed_posts()
    107 calls
    Plugin: wordpress-seo
    107 calls
    get_column_headers()
    1 call
    WP_List_Table->get_default_primary_column_name()
    106 calls

    with the deactivated yoast seo plugin is just below 25-30% and 2 seconds.

    wordpress 4.9.4
    yoast seo 7.0.3

    woocommerce 3.3.3
    products 1500

    jetpack
    cloudflare
    wp super cache
    metaslider
    wc checkout field editor
    wc pdf invoices
    wc products per page
    wc table rate shipping
    newsletter
    query monitor

Viewing 7 replies - 1 through 7 (of 7 total)
  • mdadan

    (@mdadan)

    i have the same problem

    uscarsfrance

    (@uscarsfrance)

    It looks like I have the same issue. It looks like it burns the server of my provider when displaying the WooCommerce products page.

    Plugin Support Michael Ti?a

    (@mikes41720)

    @mdadan @uscarsfrance @glamurnapani

    There was a reported issue regarding delayed loading times with the recent version of Yoast SEO, and this should be addressed with the Yoast SEO v7.1 release. When the update is released, could you please try updating to the latest version and see if this resolves the issue.

    Thread Starter glamurnapani

    (@glamurnapani)

    thanks, Michael.
    looks like yoast seo 7.0.1-9170-beta doesn’t works for me.
    loading time decrease to 3-4 seconds against 8 seconds but cpu usage still 60-95%.

    Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    @glamurnapani We apologize for any inconvenience. Can you please report your issue to the relevant issue on GitHub here so our developers can investigate this issue further.

    Thread Starter glamurnapani

    (@glamurnapani)

    https://github.com/Yoast/wordpress-seo/issues/9247

    after installing 7.1 its seems ok.
    loading time is just about 1s and cpu usage 20-30%.
    there is one warning at the query monitor:

    Warning

    Parameter 2 to sbtonly_filter() expected to be a reference, value given

    wp-includes/class-wp-hook.php:286

    WP_Posts_List_Table->prepare_items()wp-admin/edit.php:180
    wp_edit_posts_query()wp-admin/includes/class-wp-posts-list-table.php:136
    wp()wp-admin/includes/post.php:1073
    WP->main()wp-includes/functions.php:960
    WP->query_posts()wp-includes/class-wp.php:715
    WP_Query->query()wp-includes/class-wp.php:599
    WP_Query->get_posts()wp-includes/class-wp-query.php:3230
    apply_filters_ref_array(‘posts_search’)wp-includes/class-wp-query.php:1956

    Core

    Craig

    (@divithemeexamples)

    i have seen a 10x increase in my CPU since around 23rd april and after disabling other potential plugins as suggested by siteground as being the culprit im left with yoast… so, is this still a known issue? im running latest versions of everything.
    thanks

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘yoast seo woo products high cpu usage’ is closed to new replies.