That's a very good point, actually, as that will also immediately free the
space from tables you delete.
My instincts say that it's marginally slower, though; although honestly I
don't have any data to support that. Does anyone have benchmarks about that
On Tue, Sep 28, 2010 at 1:26 PM, Krishna Chandra Prajapati <
> Hi Vokern,
> I suggest to have a single ibdata1 file and use *innodb_file_per_table* to
> have multiple .ibd tables.
> On Tue, Sep 28, 2010 at 11:29 AM, Vokern <vokern@stripped> wrote:
> > Hello,
> > Currently I have the setting:
> > Because the last file of ibdata4 is very large (more than 50G), if I
> > want extend the data to more files, for example, ibdata5, ibdata6...
> > how to do it?
> > Thanks!
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=1
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel