From: Johan De Meersman Date: May 22 2012 11:37am Subject: Re: Reducing ibdata1 file size List-Archive: http://lists.mysql.com/mysql/227492 Message-Id: <7397ac37-7463-44ed-b324-4a6b2f777757@zimbra> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_a272ea49-67b2-472c-bb72-2d2a2f7bf695" --=_a272ea49-67b2-472c-bb72-2d2a2f7bf695 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Ananda Kumar" > 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 --=_a272ea49-67b2-472c-bb72-2d2a2f7bf695--