Page 1 of 1

Joomla Website Using Too Much CPU and RAM

Posted: Fri Oct 18, 2013 12:20 pm
by SOAMJENA
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.

Re: Joomla Website Using Too Much CPU and RAM

Posted: Fri Oct 18, 2013 1:26 pm
by DaveOzric
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.

Re: Joomla Website Using Too Much CPU and RAM

Posted: Fri Oct 18, 2013 5:23 pm
by SOAMJENA
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 ?

Re: Joomla Website Using Too Much CPU and RAM

Posted: Sat Oct 19, 2013 1:09 pm
by DaveOzric
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.

Re: Joomla Website Using Too Much CPU and RAM

Posted: Sat Oct 19, 2013 9:54 pm
by ranwilli
I have to wonder what the real value of a "VPS" account is.

Re: Joomla Website Using Too Much CPU and RAM

Posted: Sat Oct 19, 2013 10:17 pm
by DaveOzric
WHM

Re: Joomla Website Using Too Much CPU and RAM

Posted: Mon Oct 21, 2013 1:37 am
by SOAMJENA
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.

Re: Joomla Website Using Too Much CPU and RAM

Posted: Tue Aug 23, 2016 1:56 pm
by bobdobelina
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