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]