Announcement

Announcement Module
Collapse
No announcement yet.

InnoDb files in separated directories

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • InnoDb files in separated directories

    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

    Am I right ?

  • #2
    Hello, nobody to give me hopes ?

    yawyway wrote on Thu, 24 June 2010 16:12

    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

    Am I right ?

    Comment


    • #3
      use symlinks and read http://bugs.mysql.com/bug.php?id=18706

      Comment


      • #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.

        Comment

        Working...
        X