mysql CPU 100%

We have used the plugin several years, but with lastest update Versión 4.17.10 cpu usage of mysql increases till 100%, we have had to disable the plugin but before this we’ve tried to reduce de imports to 1 per day, delete old feeds, disable cache of the plugin,redue the number of fees to 6 in our 3 feed sources.

We’ve detected some sql that never end:

SELECT   etsinf_posts.* FROM etsinf_posts  INNER JOIN etsinf_postmeta ON ( etsinf_posts.ID = etsinf_postmeta.post_id )  INNER JOIN etsinf_postmeta AS mt1 ON ( etsinf_posts.ID = mt1.post_id )  INNER JOIN etsinf_postmeta AS mt2 ON ( etsinf_posts.ID = mt2.post_id )INNER JOIN etsinf_term_relationships tr ON etsinf_posts.ID = tr.object_id INNER JOIN etsinf_term_taxonomy tt ON tt.term_taxonomy_id=tr.term_taxonomy_id INNER JOIN etsinf_terms t ON t.term_id = tt.term_id INNER JOIN etsinf_postmeta pm ON etsinf_posts.ID = pm.post_id  WHERE 1=1  AND ( 
  etsinf_postmeta.meta_key = 'wprss_feed_id' 
  AND 
  mt1.meta_key = 'wprss_feed_id' 
  AND 
  ( mt2.meta_key = 'wprss_feed_id' AND mt2.meta_value NOT IN ('14802','9542') )
) AND etsinf_posts.post_type IN ('post', 'page', 'attachment', 'revision', 'nav_menu_item', 'custom_css', 'customize_changeset', 'oembed_cache', 'user_request', 'wp_block', 'wprss_feed', 'wprss_feed_item', 'wprss_feed_template', 'ct_faq', 'wprss_blacklist') AND ((etsinf_posts.post_status = 'publish')) OR (t.name LIKE '%Titulo%')  OR (pm.meta_key='sinonimo' AND pm.meta_value LIKE '%Titulo%')  GROUP BY etsinf_posts.ID ORDER BY etsinf_posts.post_date DESC

wordpres version 5.6
php version 7.3.6
mysql Ver 15.1 Distrib 10.3.16-MariaDB, for Win64 (AMD64), source revision 0789a1a18f0e780c0412667e7b6e0a9970aa6905

We have changed the way we acces the plugin from the number to the name like
[wp-rss-aggregator feeds=”blog-relaciones-internacionales”]
[wp-rss-aggregator feeds=”blog-empresa”]
[wp-rss-aggregator feeds=”noticias-museo-de-informatica”] without success.

As we can’t figure out the way to solve the isue, we’ve tempory disabled the plugin.

Any suggestion is welcome.

• This topic was modified 4 years, 1 month ago by fravemelupv.
• This topic was modified 4 years, 1 month ago by fravemelupv.

The page I need help with: [log in to see the link]