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.

Single High Usage MySQL process

Discussion in 'General Discussion' started by Insyder, Sep 28, 2004.

  1. Insyder

    Insyder Member

    Joined:
    Jun 29, 2003
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    I have a single process that eats up a load of memory and causes the load to skyrocket. The only info whm provides is:

    /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/primary.x1services.net.pid --skip-locking --port3306 --socket/tmp/mysql.sock

    Owned by mysql. Is it possible to track it further to a particular script? Your help is much appreciated.
     
  2. laborspy

    laborspy Well-Known Member

    Joined:
    Feb 7, 2004
    Messages:
    94
    Likes Received:
    0
    Trophy Points:
    6
    you can run "mysqladmin processlist" and it will give you a list of the processes currently being done on the mysql server. you could track it down to the user, then question them as to their scripting or actions.

    -jason
     
Loading...

Share This Page