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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
