mysql> show global variables like 'sort%';
+------------------+---------+
| Variable_name | Value |
+------------------+---------+
| sort_buffer_size | 4194296 |
+------------------+---------+
1 row in set (0.01 sec)
18 sep 2008 kl. 08.05 skrev chandru:
Hi Johan,
the query is going for a temporary table creation "Using temporary;
Using filesort"
In case your sort_buffer_size is too low please try increasing the
same. Be cautious don't try to increase it massively, since it is a
per thread memory allocation.
please let me know what is your sort_buffer_size by using the command
show global variables like 'sort%';
Regards,
Pradeep Chandru.
Johan Thorvaldsson wrote:
---------------------------------------------------------------------
Montania System AB
Halmstad
http://www.montania.se
Johan Thorvaldsson
[EMAIL PROTECTED]
Kristinebergsvägen 17, S-30241 HALMSTAD
Telefon +46(0)35-13 68 00 | Fax +46(0)35-13 68 01
