Plugin causes database CPU Spike
-
I’ve recently activated instant article plugin and it is being impossible to use it.
I am using plugin version 9.1 on WordPress 4.7.5. There is a query causing 100% usage, taking up to 5 minutes to finish. Does anyone have experienced that? Any clue on how this could be solved?
Follow below the query:
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 = ‘_instant_article_options’ ) WHERE 1=1 AND (
( wp_postmeta.meta_key = ‘_instant_article_options’ AND wp_postmeta.meta_value NOT LIKE ‘%s:12:\”exclude\\_post\”;s:7:\”exclude\”;%’ )
OR
mt1.post_id IS NULL
) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_modified DESC LIMIT 0, 3Thanks!
- The topic ‘Plugin causes database CPU Spike’ is closed to new replies.