----- Original Message -----
From: "Sabeer MZ" <sabeer.mz@stripped>
Sent: Friday, February 04, 2005 7:33 PM
Subject: Multiple Tablespace
> Hi ALL,
> Im using mySQL Distrib 4.0.18 and using single Tablespace
> Now Im planning to upgrade to 4.1.8 and move single tablespace to
> Using Per-Table Tablespaces.
there is a critical bug in innodb_file_per_table in <= 4.1.8.
You should upgrade to 4.1.9.
> Please share your expertise in moving single TB to using per-table TB
> with my existing data also.
1) Dump your tables.
2) Add to my.cnf:
3) Rebuild the whole InnoDB installation according to the advice at
Note that with multible tablespaces, a single file ibdata1:10M:autoextend is
enough. Normally, it does not grow bigger than about 100 MB.
4) Import the table dumps to MySQL. Note that importing big tables to InnoDB
can take days.
As a sidenote: Jan and Jani are working on a fast index build algorithm. In
2006, the import may be quite fast.
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM