[debian-mysql] Bug#668593: Bug#668593: mysql-server-5.1: "Incorrect key file for table" error when out of space (e.g. /tmp is tmpfs)

[Olaf van der Spek]

On Fri, Apr 13, 2012 at 2:36 PM, Ian Campbell <ijc at hellion.org.uk> wrote:
>> Why would /var/tmp be a better default?
>> Is /var/tmp guaranteed to have more space available?
>
> I thought it wasn't a tmpfs, but I don't have a system running with
> RAMTMP=yes to check now.
>
> Anyway, it was a question, don't know what the right answer is nor what
> the default should be.

http://www.pathname.com/fhs/pub/fhs-2.3.html#TMPTEMPORARYFILES
/tmp : Temporary files
/var/tmp : Temporary files preserved between system reboots

/tmp looks like the right choice

The real issue seems to be using a low capacity tmpfs for /tmp

Olaf