Perhaps if you show us the table structure and exactly what operations you are using, we might be able to provide some insight.. as it is, your report is too vague to make much sense of it.
- michael On 9/4/07, Justin <[EMAIL PROTECTED]> wrote: > 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] > > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
