From: Patrick Herber
Date: January 15 2006 10:16am
Subject: ERROR 1114 (HY000): The table is full converting a big table from MyISAM to InnoDB on 5.0.18
List-Archive: http://lists.mysql.com/mysql/193880
Message-Id: <004a01c619bc$c1128400$153605c1@DEEPBLUE>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_004B_01C619C5.22D6EC00"

------=_NextPart_000_004B_01C619C5.22D6EC00
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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:500M;ib
data5:500M;ibdata6:500M;ibdata7:500M;ibdata8:500M;ibdata9:500M;ibdata10: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.

------=_NextPart_000_004B_01C619C5.22D6EC00--