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 is needed...
Teh Chee Peng wrote: > hi, > Does anyone has any idea to improve this situation? > When I show my processlist, there is inner join query that having "Copying > to tmp Table" state, and it takes quite long time to finish the query. Any > idea to avoid Copying to tmp Table? I have tried to increase my > tmp_table_size however it does not remedy my problem. > > Thanks in advance. > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Mystische Erklärungen. Die mystischen Erklärungen gelten für tief; die Wahrheit ist, daß sie noch nicht einmal oberflächlich sind. --Friedrich Nietzsche --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
