From: Johan De Meersman Date: September 28 2010 11:38am Subject: Re: How to extend innodb files? List-Archive: http://lists.mysql.com/mysql/223153 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0003255762de8db30504915048f3 --0003255762de8db30504915048f3 Content-Type: text/plain; charset=ISO-8859-1 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 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=prajapatikc@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 --0003255762de8db30504915048f3--