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.

increasing server load because mysqld using high CPU and Memory resources

Discussion in 'General Discussion' started by markhard, Aug 22, 2006.

  1. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    lately My server load went high around 5 - 15 constantly. when i type top command i see mysqld using high CPU and memory load. from 'ps aux' command I only see 1 mysql server is running while before cpanel upgrade i see 5 mysqld is running. does this happen on your servers too?

    [​IMG]

    i see on /tmp there is alot of temporary file like:

    #sql_1142_11.MYD
    #sql_1142_11.MYI
    #sql_1142_12.MYD
    #sql_1142_12.MYI

    what is it?

    I also see alot of user name like a, b, c, d, ... while that username actually doesn't exist is this normal? as i already see it when i received the server from dedicated server provider

    [​IMG]

    on "Show Current Running Processes" page i see alot of PID that doesn't have any explanation, it's just white blanks.

    [​IMG]

    CPanel version:
    WHM 10.8.0 cPanel 10.8.2-C467
    CentOS 4.3 i686 - WHM X v3.1.0

    MySQL version:
    mysql (4.1.21-standard)

    i already run chkrootkit on my server and once there is a sniffer log file but i already delete it and chkrootkit doesn't report any sniffer anymore.
     
  2. websupport

    websupport Well-Known Member

    Joined:
    Jun 24, 2006
    Messages:
    92
    Likes Received:
    0
    Trophy Points:
    6
    Mysql Load

    Hi

    Following command will show how many current open connections there are to mysql
    mysqladmin processlist |wc -l

    Following command will display IP address and number of connections from that IP:
    netstat -plan|grep :<mysqlport>|awk {'print $5'}|cut -d: -f 1|sort|uniq -c|sort -n

    If you are getting lots of connections from specific IP then temporary block that IP address from iptables/apf.
     
  3. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    Check this out: http://forums.cpanel.net/showthread.php?t=56614
     
  4. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    thanks for your replies :)

    any comment for the strange user names and blank processes?
     
Loading...

Share This Page