Thanks a lot for your answer! However, when I used the option innodb_file_per_table I saw that the temp file (#sql...) was created in my DB directory and on this partition I still have plenty of space (more than 200GB). Do you think I CAN'T use this option for such a big table and I have to use innodb_data_file_path?
Thanks a lot and regards, Patrick > -----Original Message----- > From: Jocelyn Fournier [mailto:[EMAIL PROTECTED] > Sent: Sunday, 15 January 2006 15:09 > To: Patrick Herber > Cc: mysql@lists.mysql.com > Subject: Re: ERROR 1114 (HY000): The table is full converting > a big table from MyISAM to InnoDB on 5.0.18 > > Hi, > > I think you should change the tmpdir variable value to a > directory which > have enough room to create your temp big table (by default, > it points to /tmp dir). > > Regards, > Jocelyn > > Patrick Herber a écrit : > > Hello! > > I have a database with a big table (Data File 45 GB, Index > File 30 GB). > > Since I have some performance troubles with "table-locking" in a > > multi-user environment (when one of them performs a complex > query all > > the other have to wait up to 1 minute, which is not very > nice...), I > > would like to convert this (and other tables) into InnoDB engine. > > > > I first tried using the innodb_file_per_table option but > when running > > the statement > > > > ALTER TABLE invoice ENGINE=INNODB; > > > > ERROR 1114 (HY000): The table '#sql...' is full > > > > (this about one our after the start of the command, when > the size of > > the file was bigger than ca. 70GB (I don't know exactly the size)) > > > > I tried then without the innodb_file_per_table option, setting my > > innodb_data_file_path as follows: > > > > > innodb_data_file_path=ibdata1:500M;ibdata2:500M;ibdata3;500M;ibdata4:5 > > 00M;ib > > > data5:500M;ibdata6:500M;ibdata7:500M;ibdata8:500M;ibdata9:500M;ibdata1 > > 0:500M > > :autoextend > > > > Also in this case I got the same error message. > > > > What should I do in order to convert this table? > > > > Should I set in the innodb_data_file_path for example 50 > Files, each > > big 4GB ? > > > > Thanks a lot for your help. > > > > Best regards, > > Patrick > > > > PS: I'm running MySQL 5.0.18 on a Linux 2.6.13-15.7-smp server. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]