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
