From: Johan De Meersman
Date: September 28 2010 12:01pm
Subject: Re: How to extend innodb files?
List-Archive: http://lists.mysql.com/mysql/223156
Message-Id: <AANLkTi=P5PLMavSYUP5hfA-utQRz_XWXSfB3uEv2uhmR@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=00221532cb60cd420d0491509aca

--00221532cb60cd420d0491509aca
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Sep 28, 2010 at 1:46 PM, Vokern <vokern@stripped> 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=vegivamp@stripped
>
>


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--00221532cb60cd420d0491509aca--