start with 500MB and try On Mon, Sep 10, 2012 at 3:31 PM, Machiel Richards - Gmail < machiel.richa...@gmail.com> wrote:
> Hi, the sort_buffer_size was set to 8Mb as well as 32M for the session > (currently 1M) and retried with same result. > > > > > > On 09/10/2012 11:55 AM, Ananda Kumar wrote: > > can you trying setting sort_buffer_size to big value at your session level > and create the table > > On Mon, Sep 10, 2012 at 2:54 PM, Machiel Richards - Gmail < > machiel.richa...@gmail.com> wrote: > >> Hi >> >> We tried that as well, however the databases are quite busy and >> either other transactions overwrite the info, or there is nothing logged. >> >> We even tried running the create statement and immediately running >> Show innodb status, but nothing for that statement. >> >> Regards >> >> >> >> >> >> On 09/10/2012 11:05 AM, Ananda Kumar wrote: >> >> try this command and see if you can get more info about the error >> >> show innodb status\G >> >> On Mon, Sep 10, 2012 at 2:25 PM, Machiel Richards - Gmail < >> machiel.richa...@gmail.com> wrote: >> >>> Hi All >>> >>> I am hoping someone can point me in the right direction. >>> >>> We have a mysql 5.0 database which is giving us hassles when trying >>> to create a temporary table. >>> >>> The creation works perfectly on the slave machine as well as all our >>> other db's, however on the one specific main server we are getting the >>> message "ERROR 1005 (HY000): Can't create table >>> '/tmp/#sql4a27_68eed1_0.frm' (errno: -1)" >>> >>> >>> We have been trying to figure this out for more than a week now >>> with no luck. >>> >>> When looking in the mysql error.log file, the innodb states that >>> there is either another mysqld running (confirmed and not the case) or it >>> is a filesystem permissions problem. >>> >>> >>> We have checked several times and the permissions on the /tmp >>> filesystem is the same as on all servers. >>> >>> >>> Any suggestions would be greatly appreciated as google didnt help >>> much either. >>> >>> >>> Regards >>> >>> >>> -- >>> MySQL General Mailing List >>> For list archives: http://lists.mysql.com/mysql >>> To unsubscribe: http://lists.mysql.com/mysql >>> >>> >> >> > >