Mysql hogging CPU

For some reason mysql has been really burning CPU lately, I had a 40gb HD with 512mb RAM on a P4 2.4ghz box. I just moved to a new box with the same cpu but with 80gb HD and 1gb of RAM.

Mysql is still hogging the cpu for some reason this is what I see at the top of the PID list:

Top Process %CPU 99.9 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/deathstar.e-mpire.com.pid --skip-locking

Top Process %CPU 95.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/deathstar.e-mpire.com.pid --skip-locking

Top Process %CPU 92.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/deathstar.e-mpire.com.pid --skip-locking

Anyone else with similar issues in the past?

 

 

 

 

Top