From: Sebastian Mendel (listssebastianmendel.de)
Date: Wed Apr 23 2008 - 08:27:17 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]