On Tue, Sep 28, 2010 at 1:46 PM, Vokern <vok...@gmail.com> wrote: > Can I upgrade to innodb_file_per_table smoothly? >
When you activate it, the db will keep reading and using your existing innodb datafiles. All new tables will be created using .ibd files. Converting your existing tables is done table per table using ALTER TABLE mytable ENGINE=INNODB which will basically do a full table copy - keep I/O and lock time in mind when doing this. > > thanks. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel