_size is too large.
>
> How much RAM does the machine have? Can you check
> swap activity?
>
> On Thu, 2004-11-11 at 00:27, foo bar wrote:
> > Here's the whole the query, table structure, table
> > length and show variables output:
> >
>
t; wrote:
> Please include the full query you're running, the
> table structure, and
> the number of rows in the table. A dump of 'show
> variables;' would be
> helpful too.
>
> On Wed, 2004-11-10 at 21:44, foo bar wrote:
> > Hi Everyone,
> >
>
Hi Everyone,
I've been Googling unsuccessfully for specific issues
relating to queries run on MySQL version 4.0.16
against "tmp" tables. I have witnessed several
occurrences where queries running on various platforms
hang in a "Copying to tmp table" state for hours or
days at a time. When the sa
