I have an AMD opteron 2.6 dual processor dual core, with 4GB cache and 4GB memory... Mysql is eating up 37% of the CPU, I have a process ID, but all that is shown is
I don't know what tools you have, but if you have MySQL Administrator, you'll be able to see what queries are being run, how long they have been running for, and how many sleeping threads you may have.
Lot's of sleeping threads can eat up alot of resources. As of course can lots of heavy queries.
You have a decent server spec, so it just sounds like a bit of optimization is in order - be it status variables in mysql, or your actual queries (Or both!)