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: mysql

Discussion in 'General Discussion' started by Secret Agent, Jan 15, 2006.

  1. Secret Agent

    Secret Agent Guest

    Code:
    25763 mysql     20   0 46252  26m 2320 S 15.6  2.6   0:00.58 mysqld
    25766 mysql     20   0 46252  26m 2320 S 15.6  2.6   0:00.58 mysqld
    25450 mysql     21   0 46252  26m 2320 R 15.3  2.6   0:02.61 mysqld
    25622 mysql     20   0 46252  26m 2320 S 15.3  2.6   0:00.91 mysqld
    25764 mysql     20   0 46252  26m 2320 S 15.3  2.6   0:00.57 mysqld
    25765 mysql     19   0 46252  26m 2320 S 15.3  2.6   0:00.57 mysqld
    25768 mysql     20   0 46252  26m 2320 R 15.3  2.6   0:00.57 mysqld
    25767 mysql     21   0 46252  26m 2320 S 14.9  2.6   0:00.57 mysqld
    25452 mysql     21   0 46252  26m 2320 R 13.3  2.6   0:02.39 mysqld
    25438 mysql     25   0 46252  26m 2320 R  7.0  2.6   0:06.62 mysqld
    25769 mysql     18   0 46252  26m 2320 S  7.0  2.6   0:00.31 mysqld
    25482 mysql     18   0 46252  26m 2320 S  6.3  2.6   0:00.90 mysqld
    25717 mysql     18   0 46252  26m 2320 S  6.3  2.6   0:00.61 mysqld
    25446 mysql     18   0 46252  26m 2320 S  5.6  2.6   0:02.47 mysqld
    25456 mysql     18   0 46252  26m 2320 S  5.6  2.6   0:02.49 mysqld
    25528 mysql     18   0 46252  26m 2320 S  5.6  2.6   0:00.90 mysqld
    
    One domain shows this in cpu/memory/mysql:

    Code:
    Top Process %CPU 99.9 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/adoring.domain.com.pid --skip-locking 
    Top Process %CPU 96.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/adoring.domain.com.pid --skip-locking 
    Top Process %CPU 82.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/adoring.domain.com.pid --skip-locking 
    
    I optimized all that domain's mysql and restarted mysql. I ran killall -9 mysqld and all the processes were dead, came back again.

    What should I do from here?
     
  2. WebScHoLaR

    WebScHoLaR Well-Known Member

    Joined:
    Dec 14, 2005
    Messages:
    511
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    Planet Earth
    Run the following command from the shell:

    mysqladmin processlist

    It will show you the databases that are running queries and you can figure out the user with the help of username or database prefix and then take the necessary action.
     
Loading...

Share This Page