[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
ml at vdspek.org
Fri Apr 13 12:49:19 UTC 2012
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.
/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
More information about the pkg-mysql-maint