Hi guys,
Do you have any thoughts on how to track down a locked thread/query?
Basically we've had instances where a query locks up and causes a
cascade of locked queries and the db freezes up. By the time it's had
enough of an effect for us to see the symptoms (no new queries run)
there are a bunch of locked queries and no real way to see which one is
the initial culprit. So I was wondering:
1) is there an easy way to monitor whether or not a query is locking up
the db? does anyone have a script handy that checks for locks that can
be cronned and then an email is sent?
2) in the instance of having a bunch of locks, is there any way to track
down the query that orignated a cascade of locks?
thanks in advance for the help.
-Don
----------------------------------------------------------------------
Don Vu > Madstone Theaters
85 fifth avenue, 12th floor > new york > new york > 10003
p 212.379.1545 > f 212.989.7744 > http://www.madstonefilms.com
<http://www.madstonefilms.com/> > http://
<http://www.madstonefilms.com/> www.madstonetheaters.com
<http://www.madstonetheaters.com/>
