MySQL Log Error

[RadMan]

Just happened to be on my "Process Monitor" and every 10 or 15 seconds I get this error popping up on monitor:

2735 mysql 18 0 129m 21m 4028 S 99.7 0.5 2:59.52 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server1.buckagb.net.err --pid-file=/var/lib/mysql/server1.buckagb.net.pid

It appears to consume up to 100% of my cpu for a few seconds and then disappears.. In this instance it consumed 99.7%

Any advice would be appreciated..

 

[scsi]

You would have to run mysql query show processlist or show full processlist to see whats consuming all the resources.

You can also enable the logging of slow queries.

http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html

Search google for how to fix mysql when consuming all cpu resources.

Here is one guide I saw:

http://www.sks.com.np/article/4/reduce-high-cpu-usage-overload-problem-caused-by-mysql.html

 

[RadMan]

Thank you

You would have to run mysql query show processlist or show full processlist to see whats consuming all the resources.

You can also enable the logging of slow queries.

http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html

Search google for how to fix mysql when consuming all cpu resources.

Here is one guide I saw:

http://www.sks.com.np/article/4/reduce-high-cpu-usage-overload-problem-caused-by-mysql.html