[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)

[Ian Campbell]

On Fri, 2012-04-13 at 13:17 +0200, Olaf van der Spek wrote:
> 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?

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.

Ian.
-- 
Ian Campbell
Current Noise: The Devil's Blood - Cruel Lover

Don't I know you?