Hi Vokern, On a running MySQL Server enabling *innodb_file_per_table* makes no changes to the existing tables. The newly created table (innodb) will be affected and have thier own .ibd and .frm tables.
Although, you can enable smoothly. But it's better to have it from scratch. So, that you can reclaim the free space if required simply by dropping the table. _Krishna On Tue, Sep 28, 2010 at 5:16 PM, Vokern <vok...@gmail.com> wrote: > 2010/9/28 Krishna Chandra Prajapati <prajapat...@gmail.com>: > > Hi Vokern, > > > > I suggest to have a single ibdata1 file and use innodb_file_per_table to > > have multiple .ibd tables. > > > > Can I upgrade to innodb_file_per_table smoothly? > > thanks. >
