Hundred of Processes Eating up CPU?

[eluser]john_j[/eluser]
What Aken said is right - transactions are the usual culprits in these kind of situations. If you are using MySql, then try running SHOW PROCESSLIST (from a client like phpmyadmin) to see which query (if any) is causing this.