Errcode 28 - Rights problem

[Merlin]

Hi there,

I receive now increasingly errors from MySQL that look like this:

Error writing file '/tmp/MYWQPYEo' (Errcode: 28)

After doing some research I found that there is enough space on the
linux system but the folder itself is not mounted in a regular way:

df -h
Filesystem Size Used Avail Use% Mounted on
none 2.0G 38M 1.9G 2% /tmp

How is that possible? I can ls into that dir and there are files in it.

Any ideas on how to fix this? Thank you for any help on that topic.

Best regards,

Merlin

[Axel Schwenke]

Merlin <ngr...@fastmail.fm> wrote:
>
> I receive now increasingly errors from MySQL that look like this:
> Error writing file '/tmp/MYWQPYEo' (Errcode: 28)

~ $perror 28
OS error code 28: No space left on device

> After doing some research I found that there is enough space on the
> linux system but the folder itself is not mounted in a regular way:
>
> df -h
> Filesystem Size Used Avail Use% Mounted on
> none 2.0G 38M 1.9G 2% /tmp

Looks like being a memory based file system (tmpfs or predecessor).
What does 'mount' give?

It is not encouraged to put the MySQL tmpdir on a RAM-based file
system. Pick a location on disk and set tmpdir in my.cnf.

XL
--
Axel Schwenke, MySQL Senior Support Engineer, Sun Microsystems

MySQL User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/