Hi Caldi,
Can I knew what kind of table type you are using and also try to send me
the explain plan of the query execution.
I would like to know what kind of keys are being used.
Thanks & Regards,
Dilipkumar
Mobile: +91-9884430998
E-mail: dilipkumar.par...@eds.com
-Original Message-
From
Sender: [EMAIL PROTECTED]
Date: Tue, 24 Sep 2002 08:21:20 +0200
From: Lars Heidieker <[EMAIL PROTECTED]>
on solaris it probably a good idea to change the tmp directory from /var/tmp ->
/tmp
I recalled this feature and decided to look into linux for it's
paral
Teh,
Tuesday, September 24, 2002, 8:31:54 AM, you wrote:
TCP> Does anyone has any idea to improve this situation?
TCP> When I show my processlist, there is inner join query that having "Copying
TCP> to tmp Table" state, and it takes quite long time to finish the query. Any
TCP> idea to avoid Copy
hi,
on solaris it probably a good idee to change the tmp directory from /var/tmp ->
/tmp
as /tmp is a ram disk that gives a good performance boost if tmp tables are
involved.
The sort_buffer variable the the one to look at try increasing it, as if the
result fits into
the sort buffer no tmptable
Paste EXPLAIN SELECT ... (your SELECT); from the mysql client.
> Hi!
>
> When I join 4 tables with about 3000 records in each mysql seems to work
> forever on "copying to tmp table".
>
> I wonder what that could be. I have enough free space in the tmp-dir and
> don't know what else could it be.
