Re: Huge Innodb file

[Ware Adams]

On Sep 24, 2004, at 4:03 AM, MaFai wrote:

> Dear mysql@stripped:
>
> Here's my setting:
> innodb_data_file_path = ibdata1:10M:autoextend
>
> Now the ibdata1 has been grow up to 1.3G
>
> We try to add more ibdata file to store the data by the following 
> setting.
> innodb_data_file_path = ibdata1:1500M;ibdata2:1500M:autoextend
> innodb_data_file_path = ibdata1:10M;ibdata2:10M:autoextend

The first one is closer, but you need to specify the size of the 
current file _exactly_ (as opposed to something a little larger than it 
as you have done).  There's a pretty clear example in the manual:

<http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html>

Good luck,
Ware