yes, there some new features you can use to improve performance. If you are using mysql 5.5 and above, with files per table, you can enable BARACUDA file format, which in turn provides data compression and dynamic row format, which will reduce IO.
For more benefits read the doc On Tue, May 22, 2012 at 4:45 PM, Johan De Meersman <vegiv...@tuxera.be>wrote: > > ----- Original Message ----- > > From: "Pothanaboyina Trimurthy" <skd.trimur...@gmail.com> > > > > 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 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >
