The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

High Load Problem

Discussion in 'General Discussion' started by mnmhm2004, Aug 7, 2008.

  1. mnmhm2004

    mnmhm2004 Member

    Joined:
    Sep 26, 2006
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Hi
    i recently have a huge problem with high load
    my normal load is < 1
    but some times the load goes to 60 or 80

    the ifd report is attached

    What is the problem ?
    is this ddos attack or huge mail sending ?

    all reply appreciated

    thanks in advance
    :)
     

    Attached Files:

  2. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    Looking at the output you have forwarded, it is very clear that a database is been accessed which is using high resources and causing heavy load on your server. In order to figure out the database, execute the command when the server load is high:

    watch mysqladmin proc

    and you will see conntections to your databases (whether they are quering your database or updating). With 'watch' the output will be refreshed every couple of seconds.

    And to make sure any specific IP or range of IPs are causing problems, use the command: netstat -alntp. You will be presented with all the connections to your server with the list of remote IPs and their port numbers as well as the server port they are connected to. If you think any specific IP or a range of IP causing problem, you can block using iptables or CSF firewall (if installed).

    There are also different ways to sort such issues but it is very difficult to explain everything here in the forums.
     
  3. mnmhm2004

    mnmhm2004 Member

    Joined:
    Sep 26, 2006
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Thanks Shekhar for your reply
    i will do as you say and follow the results

    thanks again
    :cool:
     
  4. mnmhm2004

    mnmhm2004 Member

    Joined:
    Sep 26, 2006
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Hi
    i optimized mysql
    and every thing is fine now
    thanks Shekhar
     
  5. Factorhost

    Factorhost Member

    Joined:
    Sep 24, 2006
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Hi, how have you optimised it exactly?
    My load is ok but my server becomes unresponsive every couple of weeks, telltale is mysql at the mo.

    Cheers
     
  6. mhkstr

    mhkstr Member

    Joined:
    Feb 29, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    how you optmized mysql?
     
  7. mnmhm2004

    mnmhm2004 Member

    Joined:
    Sep 26, 2006
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
Loading...

Share This Page