List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:October 29 2012 10:09pm
Subject:Re: optimize and tmpfiles
View as plain text  
On Mon, October 29, 2012 18:11, walter harms wrote:
>
>
> 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
>

Well, my friend. That's a hardware problem ;^)

>
> re,
>  wh
>


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Thread
optimize and tmpfileswalter harms29 Oct
  • Re: optimize and tmpfilesReindl Harald29 Oct
    • Re: optimize and tmpfileswalter harms29 Oct
      • Re: optimize and tmpfilesReindl Harald29 Oct
        • Re: optimize and tmpfileswalter harms29 Oct
          • Re: optimize and tmpfilesReindl Harald29 Oct
          • Re: optimize and tmpfilesMogens Melander29 Oct