From: walter harms
Date: October 29 2012 5:11pm
Subject: Re: optimize and tmpfiles
List-Archive: http://lists.mysql.com/mysql/228519
Message-Id: <508EB8B1.3040200@bfs.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit



Am 29.10.2012 14:55, schrieb Reindl Harald:
> 
> 
> Am 29.10.2012 14:54, schrieb walter harms:
>>
>>
>> Am 29.10.2012 13:17, schrieb Reindl Harald:
>>>
>>>
>>> Am 29.10.2012 12:48, schrieb walter harms:
>>>> hi list,
>>>> does someone know under what circumstances ''optimize tables'' will
>>>> create a tmpfile?
>>>
>>> under all if it is MyISAM and for "select id from table order by rand();" too
>>>
>>
>> interessting, i was trying to force it (with optimize) but it did not work.
>>
>> Is there a way to restrict the maximum size of those tmpfiles?
> 
> you do you imagine restrict them?

actually i espected a no, but sometimes i have to think positv.



> they are as big as the table
> 
that is a problem with a large table


re,
 wh