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?
they are as big as the table
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
