Help needed in Joomla (Account 'robert' suspended) consume more CPU/Processor and Mem

Discussion in 'Joomla' started by smht, May 28, 2009.

  1. #1
    Dear,

    My account has been suspended from my hosting service provider due high consumption of CPU/Processor and Memory resources. Please help me to resolve this issue because I am unable to handle it, below is the detailed email I received from hosting provider.


    Your account appears to be resource intensive by nature and 9 times out of 10, this is down to the software and/or scripts used.

    This is the first suspension incident for this account so we will give you a chance to fix the resource issue. You must reply to this ticket and confirm you understand this and will do this, and we will unsuspend your account.

    If we find that this account continues to use more than it's fair share of resources, we may require that you upgrade to either a virtual private server (VPS) or a dedicated server (DS). Both of these are designed for resource heavy accounts and offer larger amounts of CPU/Memory resources.

    We look forward to hearing from you at your earliest convenience.
    =================================================================

    [root@abcd1 ~]# ps xau| grep robert
    robert 24623 0.0 0.4 82808 30008 ?? I 6:17AM 0:00.36 /usr/bin/php /home/robert/public_html/poetry/index.php
    robert 24690 0.0 0.4 82808 30272 ?? I 6:17AM 0:00.32 /usr/bin/php /home/robert/public_html/poetry/index.php
    robert 24748 0.0 0.4 82808 30008 ?? I 6:17AM 0:00.30 /usr/bin/php /home/robert/public_html/poetry/index.php
    robert 24778 0.0 0.4 82808 30008 ?? I 6:18AM 0:00.32 /usr/bin/php /home/robert/public_html/poetry/index.php
    robert 24825 0.0 0.4 82808 30008 ?? I 6:18AM 0:00.30 /usr/bin/php /home/robert/public_html/poetry/index.php
    robert 25019 0.0 0.4 82808 30324 ?? I 6:19AM 0:00.25 /usr/bin/php /home/robert/public_html/poetry/index.php
    robert 25202 0.8 0.4 82808 30312 ?? S 6:19AM 0:00.36 /usr/bin/php /home/robert/public_html/poetry/index.php
    robert 25218 0.9 0.3 76536 25840 ?? S 6:19AM 0:00.23 /usr/bin/php /home/robert/public_html/jokes/index.php



    [root@abcd1 ~]# mysqladmin pr
    +--------+------------------+-----------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +--------+------------------+-----------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    | 712743 | robert_user | localhost | robert_poetry | Query | 69 | Copying to tmp table | SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug |
    | 712794 | robert_user | localhost | robert_poetry | Query | 69 | Copying to tmp table | SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug |
    | 712824 | robert_user | localhost | robert_poetry | Query | 69 | Copying to tmp table | SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug |
    | 712857 | robert_user | localhost | robert_poetry | Query | 69 | Copying to tmp table | SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug |
    | 712886 | robert_user | localhost | robert_poetry | Query | 69 | Copying to tmp table | SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug |
    | 713009 | robert_user | localhost | robert_poetry | Query | 62 | Copying to tmp table | SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug |
    | 713152 | robert_user | localhost | robert_poetry | Query | 40 | Copying to tmp table | SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug |
    | 713259 | robert | localhost | robert_jokes | Query | 3 | Copying to tmp table | SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, |
     
    smht, May 28, 2009 IP
  2. ~kev~

    ~kev~ Well-Known Member

    Messages:
    2,866
    Likes Received:
    194
    Best Answers:
    0
    Trophy Points:
    110
    #2
    Your using joomla right? Well, just in case nobody has ever told you this - joomla is bloatware. I had the same exact problems when I was using joomla. My host kept telling me that my site was overloaded when it only had 15 people on it. Just a few hundred hits a day would overload the mysql server and the site would stop responding.

    Besides joomla being bloated, make sure your site is not image heavy. Try to get the home page down to less then 75kb. The smaller the better. Remove any resource intensive modifications you have installed. Even something as simple as a rating system will add an extra query to the database on every page load.

    To be perfectly honest, you might want to consider switching to something besides joomla. Even though a lot of people brag about it, its NOT as good as what people say.

    Or, upgrade to a bigger server.
     
    ~kev~, May 28, 2009 IP
  3. yanndc

    yanndc Banned

    Messages:
    244
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I agree that joomla is not that good. But at the same time it cannot take so much resources. I am running many Joomla sites on the same server without that issue.

    for sure you should start by changing of hosting provider. there is no way you can get your account close for that reason.

    Resources are controlled and your Joomla should stop working with memory overflow but not get the server down or whatever reason they gave you.

    It is most of the time not so good, but a good way to do it is to use the Joomla that comes with the provider in the free script area.
     
    yanndc, May 28, 2009 IP
  4. smht

    smht Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Thanks ~kev~'s and rob0000 for this nice comments but i just stuck with joomla now i change my hosting and switch to namecheap VPS 1 which have 30 GB SPACE and 512 MB Ram with Lxadmin its fine for joomla base websites?
     
    smht, May 30, 2009 IP
  5. filma

    filma Well-Known Member

    Messages:
    494
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    140
    #5
    Joomla isn't that bad. I get over 10000 visitors and i'm handling it fine :\. Probably some sort of error, i'd recommend posting this in the joomla forum. Also try enabling your cache.
     
    filma, May 30, 2009 IP
  6. free3dart

    free3dart Active Member

    Messages:
    241
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #6
    Hi smht, what's the hosting account you use.
     
    free3dart, May 30, 2009 IP
  7. gary4gar

    gary4gar Peon

    Messages:
    496
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Does not seem to be taking too many resources

    Its all under 1% CPU usage, can you post the top output?
     
    gary4gar, May 31, 2009 IP
  8. Rodder7

    Rodder7 Active Member

    Messages:
    451
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    88
    #8
    one of my joomla sites had 40k uip's per month and never had that problem. also gary had the right idea. find out your highest load and check your logs during that time. i might also consider another web host.
     
    Rodder7, Jun 1, 2009 IP
  9. smht

    smht Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Thanks this problem we are facing on webhostingbuzz.com now we can ship on Namecheap VPS.
     
    smht, Jun 2, 2009 IP
  10. ~kev~

    ~kev~ Well-Known Member

    Messages:
    2,866
    Likes Received:
    194
    Best Answers:
    0
    Trophy Points:
    110
    #10
    filma - nothing personal towards you, but you forgot to mention the begging for help part. Because there is no asking for help in the joomla forum, its more like begging or pleading for help. A lot of my questions were never answered. I even received a warning from a moderator for cross posting the question in another section - because nobody was helping me in the first section. What are people supposed to do when your questions go ignored. Ask the same question in another section of the forum and you get slapped. The joomla forums are not the place to go when you need real help.

    Caching is a good suggestion. Be sure to contact the hosting provider to see what kind of cache the server has installed and go from there.
     
    ~kev~, Jun 3, 2009 IP
  11. filma

    filma Well-Known Member

    Messages:
    494
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    140
    #11
    Well I've asked for questions for ages now on the Joomla forum, politely and never had any problems. I don't know what you mean by begging and pleading, I got my replies within 24 hours and fixed the problems up, of course you are going to get a warning for posting in the incorrect section, that is basic forum moderation.
     
    filma, Jun 6, 2009 IP