{"id":14301,"date":"2010-09-20T12:37:36","date_gmt":"2010-09-20T07:07:36","guid":{"rendered":"https:\/\/www.amitbhawani.com\/blog\/?p=14301"},"modified":"2010-09-21T18:37:27","modified_gmt":"2010-09-21T13:07:27","slug":"reduce-cpu-server-load-blogs-removing-related-posts-plugin","status":"publish","type":"post","link":"https:\/\/www.amitbhawani.com\/blog\/reduce-cpu-server-load-blogs-removing-related-posts-plugin\/","title":{"rendered":"Reduce CPU Server Load for Blogs by Removing Related Posts Plugin"},"content":{"rendered":"<p>We have been using a few useful WordPress plugins on our blogs from the past years and have always been on high server load issues because of which we had to move from shared hosting to dedicated and then move the blogs onto different services like Dedicated, VPS with backups on external drives. The blogs can get heavy spike in the sql queries mainly because of the <a href=\"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/\">WordPress<\/a> plugins which the load goes up and you will have to either upgrade the current VPS or move to a higher configuration. In order to <a href=\"https:\/\/www.amitbhawani.com\/blog\/find-server-load-of-your-websites-hosting-server\/\">Find Server Load<\/a> check out our article which is useful for more Cpanel based hosting accounts. <\/p>\n<h2>Avoid : <\/h2>\n<p>One best suggestion would be to stop using the Contextual Related Posts Plugin which is available at http:\/\/wordpress.org\/extend\/plugins\/contextual-related-posts\/. No offense to the plugin developer but we have went ahead with multiple tries and have confirmed the below graphs.<\/p>\n<p>The problem with these plugins is that whenever a blog post is read by a visitor, the plugin would run a few SQL Queries and search for other related posts based on title, content and category. This means that on every page load the server gets more resource used and when you disable these kind of plugins, the load is reduced because plugins like these need huge CPU resources.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/CPU-Server-Load-Usage.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14302\" title=\"CPU Server Load Usage\" src=\"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/CPU-Server-Load-Usage.png?resize=477%2C197\" alt=\"CPU Server Load Usage\" width=\"477\" height=\"197\" srcset=\"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/CPU-Server-Load-Usage.png?w=697&amp;ssl=1 697w, https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/CPU-Server-Load-Usage.png?resize=300%2C123&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/CPU-Server-Load-Usage.png?resize=150%2C61&amp;ssl=1 150w\" sizes=\"auto, (max-width: 477px) 100vw, 477px\" \/><\/a><\/p>\n<p>The above screenshot is taken from our Linode CPU Load Graphs section which shows the current load on the VPS and in order o give you more idea we went ahead by activating the plugin for a few minutes. It&#8217;s clearly shown the load moves to the top and because of this the blogs get frequent HTTP Error 503 Service unavailable &#038; Error establishing a database connection errors in the WordPress based blogs.<\/p>\n<h2> Recommended : <\/h2>\n<p>In order to give another solution in the form of a WordPress plugin which would allow you to display related posts on your blog and feed, we would suggest you to use the YARPP [Yet Another Related Posts Plugin] available at http:\/\/wordpress.org\/extend\/plugins\/yet-another-related-posts-plugin\/ which is quite better in terms of not just the performance but also takes very less CPU usage giving you less issues on the host. The best part is that this plugin does caching, which would increase the performance and also the speed.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/Linode-CPU-Usage.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/Linode-CPU-Usage.png?resize=477%2C197\" alt=\"Linode CPU Usage\" title=\"Linode CPU Usage\" width=\"477\" height=\"197\" class=\"aligncenter size-full wp-image-14414\" srcset=\"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/Linode-CPU-Usage.png?w=697&amp;ssl=1 697w, https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/Linode-CPU-Usage.png?resize=300%2C123&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/Linode-CPU-Usage.png?resize=150%2C61&amp;ssl=1 150w\" sizes=\"auto, (max-width: 477px) 100vw, 477px\" \/><\/a><\/p>\n<p>The above screenshot would give you a clear idea on the usage of CPU resources in the form of MySQL Queries when the plugin was activated for a limited period of time. <\/p>\n<h2>Alternative Suggestion :<\/h2>\n<p> Check out <a href=\"http:\/\/relatedlinks.googlelabs.com\/\">Google Related Links<\/a> which is a service which wont put any load on your server because it actually finds the related posts based on the Google Indexed Blog posts and pages. Do read our other <a href=\"https:\/\/www.amitbhawani.com\/blog\/tips-to-reduce-wordpress-high-server-usage-problems\/\">Tips to Reduce WordPress High Server Usage Problems<\/a>.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/Related-Links-Google.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/Related-Links-Google.png?resize=436%2C180\" alt=\"Related Links Google\" title=\"Related Links Google\" width=\"436\" height=\"180\" class=\"aligncenter size-full wp-image-14308\" srcset=\"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/Related-Links-Google.png?w=436&amp;ssl=1 436w, https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/Related-Links-Google.png?resize=300%2C123&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/Related-Links-Google.png?resize=150%2C61&amp;ssl=1 150w\" sizes=\"auto, (max-width: 436px) 100vw, 436px\" \/><\/a><\/p>\n<p>The best part of using the Related Links by Google is that you don&#8217;t put any load on your server and the results are loaded super quick.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have been using a few useful WordPress plugins on our blogs from the past years and have always been on high server load issues because of which we had to move from shared hosting to dedicated and then move the blogs onto different services like Dedicated, VPS with backups on external drives. The blogs [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":14302,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[376],"tags":[],"class_list":{"0":"post-14301","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-wordpress","8":"entry"},"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/CPU-Server-Load-Usage.png?fit=697%2C288&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":22000,"url":"https:\/\/www.amitbhawani.com\/blog\/optimizing-wordpress-cpu-consumption\/","url_meta":{"origin":14301,"position":0},"title":"Optimizing WordPress for Less CPU Consumption","author":"Amit Bhawani","date":"April 6, 2011","format":false,"excerpt":"WordPress is the CMS which is used by millions of users every single day and by default many of these users have issues with their web hosting service providers who keep complaining about the high server resource sage and then suspend the blogs for the same reason. You can signup\u2026","rel":"","context":"In &quot;Wordpress Guide&quot;","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"Optimize WordPress","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2011\/04\/Optimize-WordPress.jpg?fit=500%2C500&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":417,"url":"https:\/\/www.amitbhawani.com\/blog\/tips-to-reduce-wordpress-high-server-usage-problems\/","url_meta":{"origin":14301,"position":1},"title":"Tips to Reduce WordPress High Server Usage Problems","author":"Amit Bhawani","date":"April 14, 2008","format":false,"excerpt":"Many bloggers keep complaining that their blogs were suspended by web hosting companies because of heavy server usage and they plan to change the CMS thinking there would be problems in the CMS but the main problem is in the plugins which are you running. The best suggestion for high\u2026","rel":"","context":"In &quot;Wordpress Guide&quot;","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/high-server-load-wordpress.jpg?fit=376%2C376&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":20825,"url":"https:\/\/www.amitbhawani.com\/blog\/plugins-display-related-posts-thumbnails\/","url_meta":{"origin":14301,"position":2},"title":"Best Plugins to Display Related Posts with Thumbnails","author":"Amit Bhawani","date":"January 27, 2011","format":false,"excerpt":"If you would like to show some beautiful image thumbnails below your blog posts under related posts category then its time you should be implementing different options listed below. We have tried many different options but the best of these are listed below. Linkwithin The first of foremost recommendation would\u2026","rel":"","context":"In &quot;Wordpress Guide&quot;","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"Linkwithin WordPress Plugin","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2011\/01\/Linkwithin-WordPress-Plugin.png?fit=478%2C221&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":12993,"url":"https:\/\/www.amitbhawani.com\/blog\/vaultpress-wordpress-blogs-backup-service\/","url_meta":{"origin":14301,"position":3},"title":"VaultPress &#8211; WordPress Blogs Backup Service Review","author":"Amit Bhawani","date":"August 2, 2010","format":false,"excerpt":"There are many different WordPress sites backup service which are going to help you in backing up your complete blogs and these can be useful when you are in a problem and would like to restore your blogs. You will have to either schedule download the data to your computer\u2026","rel":"","context":"In &quot;Wordpress Guide&quot;","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"VaultPress Logo","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/08\/VaultPress-Logo.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1482,"url":"https:\/\/www.amitbhawani.com\/blog\/backup-blogs-email-computer\/","url_meta":{"origin":14301,"position":4},"title":"How to Schedule Backup Blogs to Email\/Computer","author":"Amit Bhawani","date":"September 25, 2008","format":false,"excerpt":"Its very good that you have started blogging and have started making money online but taking a backup of all your data is very important as much as is the promotion of your blog. Generally most people neglect this part when they are into serious blogging and when problems like\u2026","rel":"","context":"In &quot;How to Guide&quot;","block_context":{"text":"How to Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/how-to\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6376,"url":"https:\/\/www.amitbhawani.com\/blog\/wordpress-blog-backup-plugins-tools-tutorials\/","url_meta":{"origin":14301,"position":5},"title":"WordPress Blog Backup Plugins Tools &#038; Tutorials","author":"Amit Bhawani","date":"October 12, 2009","format":false,"excerpt":"You have been blogging from a long period and you have been making thousands of dollars from your blog but what about the security of your this money making machine? Iam not taking about any other security but the important content you have written everyday, the thousands of comments you\u2026","rel":"","context":"In &quot;Wordpress Guide&quot;","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/Wordpress-Backup-Tools-Plugins.jpg?fit=500%2C275&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts\/14301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/comments?post=14301"}],"version-history":[{"count":0,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts\/14301\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/media\/14302"}],"wp:attachment":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/media?parent=14301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/categories?post=14301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/tags?post=14301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}