I have a problem. I recently purchased a new server (dual opteron), to replace my pentium 4, which has been struggling. To my surprise, the new servers's load is about 10x of what I was getting on the p4.
Mysql being the cpu/memory hog. I noticed that there are only 2 mysql threads going. On my old box I usually had 400-500.
How can I turn off this 2 thread cap? my.cnf files on both servers are identical.
Check your /etc/my.cnf and eventualy replace with the big version.
try to skip innodb if you don't need them
Check php scripts and try to turn off persistent connections. In my experience that helps a lot.
If is dedicate only for mysql that could be from network connection.