High CPU usage

[UserQ]

Hello!

PID USER PR NIVIRT RES SHR S %CPU %MEM TIME+ COMMAND
2942 apache 20 0 103m 15m 3084 R 79 0.4 0:02.83 httpd
2466 mysql 20 0 634m 69m 4764 S 29 1.8 1:36.59 mysqld
2777 apache 20 0 98012 9544 3104 S 15 0.2 0:02.00 httpd

Try check with mytop

Cannot connect to MySQL server. Please check the:

  * database you specified "" (default is "")
  * username you specified "da_admin" (default is "root")
  * password you specified "xxxxxxx" (default is "")
  * hostname you specified "localhost" (default is "localhost")
  * port you specified "3306" (default is 3306)
  * socket you specified "" (default is "")

The options my be specified on the command-line or in a ~/.mytop
config file. See the manual (perldoc mytop) for details.

Here's the exact error from DBI. It might help you debug:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Anyone have idea how fix that?

 

[scsi]

There is nothing wrong with your ps output.

Check your mysql settings in /usr/local/directadmin/conf/mysql.conf

Restart mysql with /sbin/service mysqld restart

 

[UserQ]

ps ax | grep mysql | grep -v grep
 2393 ?        S      0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --user=mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/server.pid
 2466 ?        Sl   540:27 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --log-error=/usr/local/mysql/data/server.changeme.com.err --pid-file=/usr/local/mysql/data/server.pid

 cat /usr/local/directadmin/conf/mysql.conf
user=da_admin
passwd=xxxxxxxx

I reboot server didn't help.

 

[daveyw]

You could also login as the da_admin user like

mysql -u da_admin -p

Enter, and then the password.

After that write 'show full processlist' to check if there are strange queries.
Other thing is to check the server-status, maybe you can find there some information which page is causing it.