this temp table will hold how many rows, what would be its size. On Mon, Sep 10, 2012 at 5:03 PM, Machiel Richards - Gmail < machiel.richa...@gmail.com> wrote:
> Hi, > We confirmed that the /tmp directory permissions is set to rwxrwxrwxt > and is owned by root , the same as all our other servers. > > There is also about 60Gb of free space on the filesystem where /tmp > resides. > > Regards > > > > > > On 09/10/2012 01:11 PM, Rik Wasmus wrote: > >> the message "ERROR 1005 (HY000): Can't create table >>> '/tmp/#sql4a27_68eed1_0.frm' (errno: -1)" >>> >> Basics first: >> 1) Is the /tmp directory write & readable for the user mysql runs as? >> 2) Has the /tmp directory enough free space? >> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >