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.

CPU/Memory/MySQL Usage Overload

Discussion in 'General Discussion' started by salvatore333, Apr 19, 2007.

  1. salvatore333

    salvatore333 Well-Known Member

    Joined:
    Mar 27, 2003
    Messages:
    233
    Likes Received:
    0
    Trophy Points:
    16
    When I go to server status and CPU/Memory/MySQL Usage, there is always one customer who shows this:

    Top Process %CPU 110 /usr/local/frontpage/version5.0/exes/_vti_bin/shtml.exe


    Could somebody shed some light on how I can rectify this situation?


    Thanks for any advise.
     
  2. urantian

    urantian Well-Known Member

    Joined:
    Jan 26, 2005
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Fayetteville, Arkansas
    cPanel Access Level:
    Root Administrator
    I ran into somthing like this a few days ago, where a customer was using 97% of the CPU, throughout the day. I don't know if this is the best way to resolve it, but I found that by suspending and re-activating the account, the process stopped.

    ---Michael
     
  3. brendanrtg

    brendanrtg Well-Known Member

    Joined:
    Oct 4, 2006
    Messages:
    311
    Likes Received:
    0
    Trophy Points:
    16
    If the site is consuming too much resources, you have to let it go instead of risking your other customers.

    Maybe its a runaway script? Check the processes and figure that out.
     
  4. asiams

    asiams Well-Known Member

    Joined:
    May 28, 2003
    Messages:
    89
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Hokkaido, JAPAN
    To me mysql is using up cpu

    The user mysql is using up cpu like this:

    19728 mysql 15 0 84596 9716 2448 S 100 0.5 1:15.68 mysqld

    The automatic kill is done, but continual mysql is taking up cpu more that it should.

    Any idea?

    Thanks.

    asiams
     
  5. mohit

    mohit Well-Known Member

    Joined:
    Jul 12, 2005
    Messages:
    553
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Sticky On Internet
    hi,
    you should check what are the mysql processes that are running, you can either use whm and click show mysql processes, or use the phpmyadmin then list the processes.

    It should show you which user is running the most busy database.

    There have been issues where non-updated forum scripts are exploited and use up a lot of mysql resources for not a good reason.

    if you can use shell, it should also show you how many active mysql connections are their and what they are doing.

    see ya,
    mohit
     
  6. asiams

    asiams Well-Known Member

    Joined:
    May 28, 2003
    Messages:
    89
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Hokkaido, JAPAN
    I was able to identify the user

    Thank you mohit,

    I was able to identify who caused the problem and found out that he used bad scripts. Now it seems stable as normal.

    I am grateful for the support from all of you.

    asiams
     
  7. eglim

    eglim Member

    Joined:
    Jan 3, 2006
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    How we can check?
     
Loading...

Share This Page