[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 11:36 AM, Ian Campbell <ijc at hellion.org.uk> wrote:
> I'm not really sure if mysql's use of /tmp here is a valid one, the tmpfs had
> 2G of free space which, if mysql was using it all, is a rather large chunk to
> be going into /tmp. Would /var/tmp be a better default?

Hi Ian,

Why would /var/tmp be a better default?
Is /var/tmp guaranteed to have more space available?

Olaf