alright.. after some testing this afternoon I'm beginning to wonder if this
is a memory issue.. here's what the test was..
I did a insert select from a table that has approx 500,000 rows and the
table data is about 1gb in size.. the query went and was in the repair by
sorting phase when all of a sudden all my queries started to show up with a
state of Locked.
As soon as I killed the Insert select query all queries ran fine.
Any insight on how I can prevent this would be much appriciated.