From: Johan De Meersman Date: May 22 2012 11:15am Subject: Re: Reducing ibdata1 file size List-Archive: http://lists.mysql.com/mysql/227487 Message-Id: <752e4e37-0ea5-461d-a8ec-eb059d0f2c8d@zimbra> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Pothanaboyina Trimurthy" > > hi sir, Please keep the list in CC, others may benefit from your questions, too. > can we see any performance related improvements if we use > "innodb_file_per_table" other than using a single ibdatafile for all > innodb databases. Please let me know the difference sir. No, that shouldn't yield any particular performance benefit, as far as I'm aware. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel