Yoast SEO generates slow queries
-
Hello, I have seen numerous topics most without any replies on this subject.
Yoast is generating slow queries. I have checked the server MySQL slow log and there have been 11 slow database queries all towards the users and usermeta tables of my website’s database.
The queries appear to be running slow due to the amount of examined rows – 200 000 to over 2 million rows per query, which is a very high number, given that the users table is just over 1100 rows and the usermeta about 39 000 rows.
SELECT DISTINCT wp_users.ID FROM wp_users LEFT JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) LEFT JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id ) LEFT JOIN wp_usermeta AS mt2 ON ( wp_users.ID = mt2.user_id ) LEFT JOIN wp_usermeta AS mt3 ON (wp_users.ID = mt3.user_id AND mt3.meta_key = ‘wpseo_noindex_author’ ) LEFT JOIN wp_usermeta AS mt4 ON ( wp_users.ID = mt4.user_id ) WHERE 1=1 AND (
(
(
wp_usermeta.meta_key = ‘_yoast_wpseo_profile_updated’
AND
(
( mt1.meta_key = ‘wp_user_level’ AND mt1.meta_value != ‘0’ )
AND
(
( mt2.meta_key = ‘wpseo_noindex_author’ AND mt2.meta_value != ‘on’ )
OR
mt3.user_id IS NULL
)
)
)
AND
( mt4.meta_key = ‘wp_user_level’ AND mt4.meta_value != ‘0’ )
)
) ORDER BY wp_usermeta.meta_value+0 DESC;
- The topic ‘Yoast SEO generates slow queries’ is closed to new replies.
