From: Date: April 23 2008 3:27pm
Subject: Re: Symlink InnoDB tables without stoping MySQL
List-Archive: http://lists.mysql.com/mysql/212458
Message-Id: <480F3935.3060006@sebastianmendel.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Dobromir Velev schrieb:
> Hi,
> What I'm trying to do is to create a new InnoDB table on a different disk and 
> symlink it to an existing database.
> I have innodb_file_per_table turned on and here is how I tried to do it
> 
> 
> mysql> \u test
> mysql> create table test (...) ENGINE  = 'InnoDB';
> mysql>\q
> 
> move the test.ibd file to the other disk
> create a simlink in the database directory
> flush tables;
> 
> 
> This works as expected but there is something that bothers me - I inserted 
> about 60K rows in the new table and all queries I tried are working  
> including selects, inserts and updates. The "SHOW TABLE STATUS" command 
> displays relevant results and still the test.ibd file to which the symlink 
> points hasn't been changed or accessed at all.
> 
> Any ideas are welcome

you need to setup per-table tablespace, did you?

Section 13.2.3.1, “Using Per-Table Tablespaces”.

http://dev.mysql.com/doc/refman/5.0/en/innodb-init.html

-- 
Sebastian Mendel