At 22:13 07.04.2005, Gleb Paharenko wrote:
Hello.

According to:
  http://dev.mysql.com/doc/mysql/en/show-processlist.html

the temporary result set was larger than tmp_table_size and the thread
is changing the temporary table from in-memory to disk-based format to
save memory. I suggest you to play with the value of this variable which
is now:

tmp_table_size 33554432

after set this value 2 times bigger, we have the old speed. thanks for help!

Best Regards,
Rafal



-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to