yes, Barracuda is limited to FILE_PER_TABLE. Yes, true there is CPU cost, but very less. To gain some you have to loss some.
On Tue, May 22, 2012 at 5:07 PM, Johan De Meersman <vegiv...@tuxera.be>wrote: > ------------------------------ > > *From: *"Ananda Kumar" <anan...@gmail.com> > > > 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. > > > True, but Barracuda isn't limited to file-per-table, is it? > > Also, while it's true that compression will lighten your I/O load, do not > forget that it does so at the cost of additional CPU load. There's no such > thing as a free lunch :-) > > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel >