Joomla Website Using Too Much CPU and RAM

Discussion regarding Joomla! 2.5 Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
User avatar
SOAMJENA
Joomla! Ace
Joomla! Ace
Posts: 1219
Joined: Thu May 01, 2008 12:36 pm
Location: QubeSys Technologies Pvt. Ltd ,INDIA
Contact:

Joomla Website Using Too Much CPU and RAM

Postby SOAMJENA » Fri Oct 18, 2013 12:20 pm

We have a Joomla website which hardly gets 500-600 unique visits per day. Its one of the only 6 sites, which are hosted on the 1GB VPS account at LiquidWeb.

I asked them root cause of this load spikes and they said, the Joomla site is the culprit.

And replied this,

I took a look at the slow log for MySQL. It looks like most of the reported slow logs are related to user/database: joomcd_xxxx It is not the only one, but it is the majority.

That may give an indication as to why the Joomla site is being listed as a high resource usage.


So, how do we debug whats going on and how to fix it ?

I cant imagine such a small Joomla site trying to take down the server 5 times every hour and Im losing business, clients , money and all of my time on it.
Web Design, eCommerce and Software Development
Joomla Premium Extensions,Templates and Support Packages

User avatar
DaveOzric
Joomla! Ace
Joomla! Ace
Posts: 1399
Joined: Sat May 22, 2010 10:29 pm
Contact:

Re: Joomla Website Using Too Much CPU and RAM

Postby DaveOzric » Fri Oct 18, 2013 1:26 pm

Are you able to use any caching to avoid all the queries? Repairing and optimizing the database helps.

Check the stats in awstats (cpanel) and see how much traffic/requests you are really getting. Visitors are only a fraction of traffic. I had a site and my hosting company said the same thing and the access logs showed bingbots were requesting pages 37,000 times per day causing the same issues with database and CPU.

I ended up switching PHP handlers which has really helped.

User avatar
SOAMJENA
Joomla! Ace
Joomla! Ace
Posts: 1219
Joined: Thu May 01, 2008 12:36 pm
Location: QubeSys Technologies Pvt. Ltd ,INDIA
Contact:

Re: Joomla Website Using Too Much CPU and RAM

Postby SOAMJENA » Fri Oct 18, 2013 5:23 pm

DaveOzric wrote:Are you able to use any caching to avoid all the queries? Repairing and optimizing the database helps.

Check the stats in awstats (cpanel) and see how much traffic/requests you are really getting. Visitors are only a fraction of traffic. I had a site and my hosting company said the same thing and the access logs showed bingbots were requesting pages 37,000 times per day causing the same issues with database and CPU.

I ended up switching PHP handlers which has really helped.


What did you change the PHP handler to ?
Web Design, eCommerce and Software Development
Joomla Premium Extensions,Templates and Support Packages

User avatar
DaveOzric
Joomla! Ace
Joomla! Ace
Posts: 1399
Joined: Sat May 22, 2010 10:29 pm
Contact:

Re: Joomla Website Using Too Much CPU and RAM

Postby DaveOzric » Sat Oct 19, 2013 1:09 pm

DSO and mod_ruid2

So far it's working well. There are a number of things to be aware of from what I read. I would thoroughly research this before tying it. mod_security is one that no longer is compatible for example.

User avatar
ranwilli
Joomla! Master
Joomla! Master
Posts: 19053
Joined: Sun Feb 19, 2006 6:47 pm
Location: Toledo, OH
Contact:

Re: Joomla Website Using Too Much CPU and RAM

Postby ranwilli » Sat Oct 19, 2013 9:54 pm

I have to wonder what the real value of a "VPS" account is.
Don't HACK the Joomla! core. Extend and Override.
Stay ON the update path.
http://harpervance.com

User avatar
DaveOzric
Joomla! Ace
Joomla! Ace
Posts: 1399
Joined: Sat May 22, 2010 10:29 pm
Contact:

Re: Joomla Website Using Too Much CPU and RAM

Postby DaveOzric » Sat Oct 19, 2013 10:17 pm

WHM

User avatar
SOAMJENA
Joomla! Ace
Joomla! Ace
Posts: 1219
Joined: Thu May 01, 2008 12:36 pm
Location: QubeSys Technologies Pvt. Ltd ,INDIA
Contact:

Re: Joomla Website Using Too Much CPU and RAM

Postby SOAMJENA » Mon Oct 21, 2013 1:37 am

Here is my Slow Log file,
http://d.pr/f/8JQJ

Can you check, what is affecting please ?

I can then search for ways to optimize it.
Web Design, eCommerce and Software Development
Joomla Premium Extensions,Templates and Support Packages

bobdobelina
Joomla! Apprentice
Joomla! Apprentice
Posts: 23
Joined: Fri Jul 01, 2016 5:56 pm

Re: Joomla Website Using Too Much CPU and RAM

Postby bobdobelina » Tue Aug 23, 2016 1:56 pm

Did anyone solve this problem? I went live with a site last Thursday and I'm having to reboot my server every 24 hours as the RAM is exceeding the 2GB limit.

I have a number of other Joomla sites on the VPS with no problems. The only difference with this one is I have Komento, Spambotcheck and Fieldsattach plugins installed. I'm also using MySQLi but all other sites are MySQL.

Any tips on how to solve this as I can't disable any of those plugins.

Many thanks


Return to “Performance - Joomla! 2.5”

Who is online

Users browsing this forum: No registered users and 3 guests