InnoDb files in separated directories

MySQL & MariaDB Other MySQL® Questions
1

Hi all,
I’ve just realized that I couldn’t use DATA DIRECTORY and INDEX DIRECTORY options of CREATE TABLE command with InnoDB engine.

I use innodb_file_per_table, so it seems I will not be able to put some InnoDB tables on my second RAID stack :frowning:

Am I right ?

2

Hello, nobody to give me hopes ?

[B]yawyway wrote on Thu, 24 June 2010 16:12[/B]
Hi all, I've just realized that I couldn't use DATA DIRECTORY and INDEX DIRECTORY options of CREATE TABLE command with InnoDB engine.

I use innodb_file_per_table, so it seems I will not be able to put some InnoDB tables on my second RAID stack :frowning:

Am I right ?

3

use symlinks and read [URL]MySQL Bugs: #18706: InnoDB Tablespace per Table Symlink causes InnoDB Cache Load Error

4

gmouse is right. These options only work for MyISAM tables, so you have to do something like symlink a database to another device. Symlinking the table files themselves really won’t work. also, if you use ALTER, it also can replace your symlinks with real files, effectively moving your tables back where you don’t want them.