From: Johan De Meersman Date: May 22 2012 11:52am Subject: Re: Reducing ibdata1 file size List-Archive: http://lists.mysql.com/mysql/227496 Message-Id: <8b8816de-780e-42b7-8f01-72d36d22f361@zimbra> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_e86a7018-b6b6-4294-9f66-94cbaf747f1e" --=_e86a7018-b6b6-4294-9f66-94cbaf747f1e Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Ananda Kumar" > yes, Barracuda is limited to FILE_PER_TABLE. Ah, I didn't realise that. Thanks :-) > Yes, true there is CPU cost, but very less. > To gain some you have to loss some. I've only got it enabled on a single environment, but enabling it added about 20% of a single vcore to the CPU usage. Very visible (and not problematic) because that system isn't CPU-bound :-) Converting an existing table to the compressed format did shoot the CPU through the roof, though. See http://www.tuxera.be/filestore/vefeuraxinie/mysql-cpu-year.png for an interesting graph. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --=_e86a7018-b6b6-4294-9f66-94cbaf747f1e--