List:General Discussion« Previous MessageNext Message »
From:Akshay Suryavanshi Date:September 10 2012 12:40pm
Subject:Re: Temporary table creation fails
View as plain text  
Hi,

If you can afford try changing the tmpdir for mysql. This is a static
variable and will require a mysql restart.

thanks

On Mon, Sep 10, 2012 at 6:08 PM, Machiel Richards - Gmail <
machiel.richards@stripped> wrote:

> Hi
>
>
> at the moment this does not really matter to us.
>
>     we have even tried to create a temp table with only one field in order
> to insert one row for testing, but we are currently not able to create any
> temporary tables whatsoever as even the simplest form of table still gives
> the same error.
>
> Regards
>
>
>
> On 09/10/2012 02:33 PM, Ananda Kumar wrote:
>
>> 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.richards@stripped
> <mailto:machiel.richards@**gmail.com<machiel.richards@stripped>>>
>> 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
>>
>>
>>
>

Thread
Temporary table creation failsMachiel Richards - Gmail10 Sep
  • Re: Temporary table creation failsAnanda Kumar10 Sep
    • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
      • Re: Temporary table creation failsAnanda Kumar10 Sep
        • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
          • Re: Temporary table creation failsAnanda Kumar10 Sep
            • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
              • Re: Temporary table creation failsAkshay Suryavanshi10 Sep
                • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
  • Re: Temporary table creation failsRik Wasmus10 Sep
    • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
      • Re: Temporary table creation failsAnanda Kumar10 Sep
        • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
          • Re: Temporary table creation failsAnanda Kumar10 Sep
            • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
              • Re: Temporary table creation failsAnanda Kumar10 Sep
          • Re: Temporary table creation failsAkshay Suryavanshi10 Sep
Re: Temporary table creation failsGarot Conklin10 Sep
  • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
    • Re: Temporary table creation failsManuel Arostegui10 Sep
Re: Temporary table creation failsGarot Conklin10 Sep
  • Re: Temporary table creation failsShawn Green10 Sep