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.

Mysql usage

Discussion in 'General Discussion' started by adapter, Mar 4, 2004.

  1. adapter

    adapter Well-Known Member
    PartnerNOC

    Joined:
    Sep 17, 2003
    Messages:
    391
    Likes Received:
    0
    Trophy Points:
    16
    Hello

    i have check in the WHM the Cpu and Mysql usage after that my server crashed

    User Domain %CPU %MEM Mysql Processes
    mysql 11.48 260.09 0.0
    Top Process %CPU 1.6 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/solaris.dnshighspeed.com.pid --skip-locking
    Top Process %CPU 1.5 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/solaris.dnshighspeed.com.pid --skip-locking
    Top Process %CPU 1.2 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/solaris.dnshighspeed.com.pid --skip-locking

    it's seem to be a Mysql abuse, how can i track the account that used all this resource?
     
  2. dxer

    dxer Well-Known Member

    Joined:
    Sep 9, 2002
    Messages:
    295
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Europe
    I have the same problem and I don't know how to fix it. If someone have an ideas how to fix this please help.

    mysql 14.13 7.49 0.0 marked in YELLOW !
    Top Process %CPU 84.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/medialink01.pid --skip-locking
    Top Process %CPU 79.9 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/medialink01.pid --skip-locking
    Top Process %CPU 79.4 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/medialink01.pid --skip-locking
     
  3. alex kada

    alex kada Member

    Joined:
    Nov 9, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    same problem here !!
     
Loading...

Share This Page