CODEWITHSUNDEEP
phpmysqlwordpress
user2151960
user2151960

Reputation: 185

Wordpress High CPU Usage

I received an email from my hosting provider (hostgator) telling me that: "Your account has been placed under resource restriction! Your account has exceeded our extreme usage threshold for several hours..."

Logs of the CPU usage are provided below: CPU seconds used in the past hour: 3318.56999999999, 93% CPU

Tue Sep 3 21:01:10 CDT 2013 Running Processes: user 21172 60.0 0.1 340216 50288 ? RN 21:01 0:00 /usr/bin/php /home1/user/public_html/index.php

Running Queries: ************* 1. row ************* USER: user_db DB: name_db STATE: Sorting result TIME: 0 COMMAND: Query INFO: SELECT ID, post_title, meta_value FROM wp_posts, wp_postmeta WHERE wp_posts.ID = wp_postmeta.post_id AND post_status='publish' AND post_type='post' AND meta_key='_liked' ORDER BY wp_postmeta.meta_value+0 DESC LIMIT 10

Can anyone explain me what is this and how to solve?

Upvotes: 0

Views: 2070

Answers (2)

josefresco
josefresco

Reputation: 108

Most likely it's not your site that is the problem/cause. HostGator's shared account performance has been poor for sites that rely on MySQL even since their purchase by EIG and subsequent server migration in late 2013.

I speak from experience, as I host 40+ WordPress blog with HostGator, and have seen performance issues with almost all of them, despite each having different plugins, traffic levels and themes.

Find another (non EIG) web host, and if you can afford it upgrade to a VPS that can scale based on your needs as shared hosting is always a gamble.

Upvotes: 0

Naeem Sabasara
Naeem Sabasara

Reputation: 73

First of all you should have to install " WP Overview (lite) Footer Memory Usage " plugin on your server and you can check it...

And also install " W3 Total Cache " and cache your files and images from the server. You can increase a speed of your side with this plugin.

Upvotes: 1

Related Questions