From: walter harms
Date: October 29 2012 11:48am
Subject: optimize and tmpfiles
List-Archive: http://lists.mysql.com/mysql/228514
Message-Id: <508E6D03.6020003@bfs.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

hi list,
does someone know under what circumstances ''optimize tables'' will
create a tmpfile ?

we had a strange case of "out of space" that seems related to an "optimize table"
but i was unable to replicate that case exactly as that no tmpfile appeared.
(The table has a lot of partitions if that matters.)

re,
 wh