On Tue, Oct 21, 2008 at 8:26 AM, Heston James - Cold Beans < [EMAIL PROTECTED]> wrote:
> 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 > > 1. Just because your data set is small does not mean that mysql will not create a larger temporary file to store a temporary table. 2. If I had to guess I would say some sort of quota is in effect, also possibly for /tmp/ in particular. -- Rob Wultsch
