Every now and then, mysqld (5.0.22) jumps to 95%+ cpu usage and stays
there. Seems to be a common issue, as far as google can tell, but
details are alarmingly vague, and some people seem to suggest that
it’s a bad query causing it. How do I go about determining if it’s
something my application is doing?