This decision was made before InnoDB was the default. While the performance differences are historical now, consider the case that because of fixed sized buffe

This decision was made before InnoDB was the default. While the performance differences are historical now, consider the case that because of fixed sized buffers, one query could switch from a temp table in memory to a temp table on disk. The profile of the query has effectively changed.