Yoast bomb the mysql

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.