s/columns if
you can't let them be seen. :-) Hint: use \G instead of ; at the end of
the EXPLAIN query to make the output more legible.
Matt
- Original Message -
From: "Kevin Fries"
Sent: Friday, September 05, 2003 11:09 AM
Subject: RE: Query hung up in "Copying to tm
in
> -Original Message-
> From: Matt W [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2003 1:37 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Query hung up in "Copying to tmp table"
>
>
> Hi Kevin,
>
> I imagine the query is examini
ables
(rows and MB).
Matt
- Original Message -
From: "Kevin Fries"
Sent: Wednesday, September 03, 2003 6:51 PM
Subject: Query hung up in "Copying to tmp table"
> I'm having a problem where a complex SELECT query begins eating up
lots
> of CPU and never
I'm having a problem where a complex SELECT query begins eating up lots
of CPU and never returns. In "show processlist", it
reports "Copying to tmp table". Other queries seem to get locked
waiting for this query, as well.
This is on version 3.23.36 of mySQL, and I'm considering upgrading to
the