mysqld high CPU after update
-
The website is incredibly slow and has very high CPU utilization with mysqld when trying to view ‘All Posts’ via /wp-admin/edit.php
The only solution was to disable the plugin.
Here is the slow query:
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) INNER JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id )
WHERE 1=1 AND (
(
wp_postmeta.meta_key = ‘beyondwords_error_message’
AND
( mt1.meta_key = ‘beyondwords_error_message’ AND mt1.meta_value != ” )
)
OR
(
mt2.meta_key = ‘speechkit_error_message’
AND
( mt3.meta_key = ‘speechkit_error_message’ AND mt3.meta_value != ” )
)
) AND ((wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ 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, 25
- The topic ‘mysqld high CPU after update’ is closed to new replies.
