List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:September 28 2010 11:38am
Subject:Re: How to extend innodb files?
View as plain text  
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 <
prajapatikc@stripped> wrote:

> Hi Vokern,
>
> I suggest to have a single ibdata1 file and use *innodb_file_per_table* to
> have multiple .ibd tables.
>
> _Krishna
>
> On Tue, Sep 28, 2010 at 11:29 AM, Vokern <vokern@stripped> wrote:
>
> > Hello,
> >
> > Currently I have the setting:
> >
> >
> >
> innodb_data_file_path=ibdata1:10G;ibdata2:10G;ibdata3:10G;ibdata4:10G:autoextend
> >
> > 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

Thread
How to extend innodb files?Vokern28 Sep
  • Re: How to extend innodb files?Carlos Proal28 Sep
    • Re: How to extend innodb files?Jangita28 Sep
      • Re: How to extend innodb files?Vokern28 Sep
        • Re: How to extend innodb files?Johan De Meersman28 Sep
  • Re: How to extend innodb files?Krishna Chandra Prajapati28 Sep
    • Re: How to extend innodb files?Johan De Meersman28 Sep
    • Re: How to extend innodb files?Vokern28 Sep
      • Re: How to extend innodb files?Krishna Chandra Prajapati28 Sep
      • Re: How to extend innodb files?Johan De Meersman28 Sep
Re: How to extend innodb files?Jan Steinman28 Sep
  • Re: How to extend innodb files?Johan De Meersman29 Sep