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