otherwise mysql 5.5+ may create the temp table as innodb (i.e., on disk) before you can convert it to memory