EMERGENCY! Update Statement for critical mysql production database now running for 18 hours, need help
Try looking at the output of SHOW PROCESSLIST; it should give you a brief idea of what's going on inside that thread; worst case scenario, you could kill that thread (using KILL $threadID) and then cleaning up manually.
HTH.