It turns out that even when we
specify MEMORY for temp tables, MySQL still has the option of writing to
disk if other buffers aren't large enough.