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 tmp table
Matt,
Thanks for your response. It's going to take a bit for me to get the
actual
[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 examining/returning so many rows that
it's going to take a long time to create the needed temporary
table
(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 returns. In show processlist, it
reports
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