Hi, rec’d this email from my hosting provider because they disabled the plugin because it was crashing the site repeatedly.
Am I doing something wrong? Is there a possible fix? This plugin was amazing and working really well, but seems to be the source of my issues the last few weeks.
Customer has a database called (fis1118909210684) which is causing excessive CPU usage on the server. This excessive CPU usage is due to a plugin on the WordPress called “wordpress-popular-posts.” This plugin runs subqueries which cause a significant amount of load on the server. An example of the query can be found below. Customer needs to review this plugin and determine if it is absolutely essential. It is suggested the customer remove this plugin if not needed. If the customer does need this plugin, the customer must find a way to optimize the use of this plugin so it is not issuing such expensive transactions. Customer may do this on their own or they may wish to hire a professional to do this for them. To immediately address the impact this plugin was causing the server, we have changed the permissions on this plugin to 000 at the location (html/wp-content/plugins/wordpress-popular-posts). Customer may alter the permissions of this plugin at anytime, but is likely to be netvio’ed again should they alter the perms before addressing the issue.
Please contact the customer and advise a review of this plugin to ensure that such costly transactions are avoided.
SELECT p.ID AS ‘id’ , p.post_title AS ‘title’ , p.post_date AS ‘date’ , p.post_author AS ‘uid’ , v.pageviews AS ‘pageviews’ FROM (SELECT id , SUM(pageviews) AS pageviews , MAX(day) AS day FROM wp_popularpostsdatacache WHERE day > DATE_SUB(‘2013-09-16 19:36:03’ , INTERVAL 1 WEEK) GROUP BY id ORDER BY pageviews DESC , day DESC) v LEFT JOIN wp_posts p ON v.id = p.ID WHERE p.post_type IN(‘post’ , ‘page’) AND p.ID NOT IN ( SELECT object_id FROM wp_term_relationships AS r JOIN wp_term_taxonomy AS x ON x.term_taxonomy_id = r.term_taxonomy_id JOIN wp_terms AS t ON t.term_id = x.term_id WHERE x.taxonomy = ‘category’ AND t.term_id IN(6337 , 8310 ) ) AND p.post_password = ” AND p.post_status = ‘publish’ LIMIT 10
- The topic ‘Host disabled plugin due to excessive CPU usage and sub queries’ is closed to new replies.