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.
thanks
Ju.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]