please help - mysql - high cpu usage!!

[50c]

Hi,
im having some problems with mysql.
After i restart mysql, the CPU load is ok, after some time 10-15 minutes the load starts increasing... I have checked the processes and this is the problem:

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/dualxeon.compacthost.com.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock

This process eats about 90% of CPU, after some time it gets back to normal.. i have no idea what it could be..

Here is my my.cnf:

# The MySQL server
[mysqld]
port = 3306
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=64M
query_cache_type=1

max_connections = 448
max_user_connections = 448

interactive_timeout=6
wait_timeout=6
connect_timeout=6

thread_cache_size=384
key_buffer=96M

max_allowed_packet=1M
table_cache=512
record_buffer=1M
sort_buffer_size=1M
read_buffer_size=1M

thread_concurrency=4
myisam_sort_buffer_size=64M
server-id=1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=2M
write_buffer=2M

[mysqlhotcopy]
interactive-timeout

The machine is a DualXeon 2,4GHZ with 2 GB of ram...

Please Help..
Thanks

Mike

[AndyReed]

im having some problems with mysql.
After i restart mysql, the CPU load is ok, after some time 10-15 minutes the load starts increasing... I have checked the processes and this is the problem:

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/dualxeon.compacthost.com.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock

This process eats about 90% of CPU, after some time it gets back to normal.. i have no idea what it could be.

The problem is NOT MySQL itself. You need to see who is exahusting many concurrnet connections causing high server load. Use mytop to monitor MySQL processes.