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