Hundred of Processes Eating up CPU?

[eluser]Aken[/eluser]
Are you using MySQL transactions at all? An open-ended transaction can mess up performance in a hurry.

That's my first guess. It could be a lot of different things, probably. I'm not experienced with actual server performance, but I've seen bad transactions go haywire before.