List:General Discussion« Previous MessageNext Message »
From:walter harms Date:October 29 2012 1:54pm
Subject:Re: optimize and tmpfiles
View as plain text  

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 ?

re,
 wh
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