• Resolved rani666

    (@rani666)


    Hi, after installing the plug in and activating
    I gets this query every second in my mysql, and it slow down my website

    what should I do?

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id AND mt1.meta_key = ‘_yoast_wpseo_primary_category’ ) WHERE 1=1 AND (
    wp_term_relationships.term_taxonomy_id IN (1,67,71,123,125,126,127,129,130)
    ) AND (
    ( wp_postmeta.meta_key = ‘_yoast_wpseo_primary_category’ AND wp_postmeta.meta_value LIKE ‘%1%’ )
    OR
    mt1.post_id IS NULL
    ) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 4

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

    (@mazedulislamkhan)

    Thanks for bringing this to our attention. A bug report is currently in the Yoast SEO GitHub repository about the slow query issue and our development team is working hard to fix it. We have also added your provided slow query to the relevant issue to ensure it fixes in the future update.

    If you’d like you can follow the progress of the report here.

    Closed due to inactivity.

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
    FROM wp_posts
    LEFT JOIN wp_postmeta
    ON ( wp_posts.ID = wp_postmeta.post_id )
    LEFT JOIN wp_postmeta AS mt1
    ON (wp_posts.ID = mt1.post_id
    AND mt1.meta_key = ‘yst_prominent_words_version’ )
    WHERE 1=1
    AND ( ( wp_postmeta.meta_key = ‘yst_prominent_words_version’
    AND wp_postmeta.meta_value != ‘1’ )
    OR mt1.post_id IS NULL )
    AND wp_posts.post_type = ‘page’
    AND ((wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘future’
    OR wp_posts.post_status = ‘draft’
    OR wp_posts.post_status = ‘pending’
    OR wp_posts.post_status = ‘private’))
    GROUP BY wp_posts.ID
    ORDER BY wp_posts.post_date DESC
    LIMIT 0, 10

    Super Slow. Where is teh fix.

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID NOT IN (283833) AND ( \n wp_term_relationships.term_taxonomy_id IN (1)\n) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘closed’ OR wp_posts.post_status = ‘acf-disabled’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 6

    Site crashed.

    ANYONE found a fix?

    • This reply was modified 7 years, 3 months ago by dandr69.
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Yoast bomb the mysql’ is closed to new replies.