Afternoon all,
I have a SELECT query which is returning the following error:
(InternalError) (3, "Error writing file '/tmp/MYqlGnfn' (Errcode: 28)")
After doing a little searching on google all signs seem to point to a lack
of disk space to be able to store the query results.
However, I have several hundred MB left on the storage device and the
database itself, in its entirety is only around 19Mb in size so it sees very
strange to be causing that. Here is a quick output from 'fd -h' which
displays the space on my storage device.
Filesystem Size Used Avail Use% Mounted on
rootfs 973M 595M 330M 65% /
udev 10M 20K 10M 1% /dev
/dev/disk/by-label/ROOT_FS
973M 595M 330M 65% /
/dev/disk/by-label/ROOT_FS
973M 595M 330M 65% /dev/.static/dev
tmpfs 126M 0 126M 0% /lib/init/rw
tmpfs 126M 0 126M 0% /dev/shm
tmpfs 8.0M 0 8.0M 0% /rw/tmp
Can anyone offer any suggestions as to what might be causing this issue and
anything I can do to correct this? I'd really appreciate some help. I'm
running MySQL 5 on a Debian based system.
If you need any more information what so ever, please let me know.
Cheers in advance,
Heston
