Memory Issue would someone confirm

[Michael Dykman]

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 <mysql@stripped> 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/mysql?unsub=1
>
>


--
 - michael dykman
 - mdykman@stripped

 - All models are wrong.  Some models are useful.


-- 
 - michael dykman
 - mdykman@stripped

 - All models are wrong.  Some models are useful.