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 < prajapat...@gmail.com> 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 <vok...@gmail.com> 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=prajapat...@gmail.com > > > > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel