Mysqld taking up 100% cpu

Rails
1

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?

martin

2

development.log has all the SQL statement available for view… I’d
bring this one to the mysql list tho.

3

Also if the cpu usage is high for a sustained period, try running
‘mysqladmin processlist’ from the command line and you’ll see exactly
what’s happening while it’s running at high load.

Ross