From: Reindl Harald
Date: May 22 2012 11:57am
Subject: Re: Reducing ibdata1 file size
List-Archive: http://lists.mysql.com/mysql/227497
Message-Id: <4FBB7F2B.9040204@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig8B848178DDF1B7C40DD967DF"

--------------enig8B848178DDF1B7C40DD967DF
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable



Am 22.05.2012 13:52, schrieb Johan De Meersman:
> ----- Original Message -----
>=20
>> From: "Ananda Kumar" <anandkl@stripped>
>=20
>> yes, Barracuda is limited to FILE_PER_TABLE.
> Ah, I didn't realise that. Thanks :-)=20
>=20
>> Yes, true there is CPU cost, but very less.
>> To gain some you have to loss some.
>=20
> 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 prob=
lematic) because that system isn't CPU-bound :-) Converting an existing t=
able to the compressed format did shoot the CPU through the roof, though.=
=20
>=20
> See http://www.tuxera.be/filestore/vefeuraxinie/mysql-cpu-year.png for =
an interesting graph

interesting because i have here a dbmail-server with no CPU load and
innodb with compression enabled since 2009 (innodb plugin in the past)

[--] Data in InnoDB tables: 6G (Tables: 49)
[--] Up for: 5d 0h 44m 10s (455M q [1K qps], 50K conn, TX: 36B, RX: 13B)
[--] Reads / Writes: 90% / 10%
[--] Total buffers: 4.1G global + 1.2M per thread (500 max threads)
[OK] Maximum possible memory usage: 4.7G (54% of installed RAM)
[OK] Slow queries: 0% (3/455M)
[OK] Highest usage of available connections: 18% (93/500)
[OK] Key buffer size / total MyISAM indexes: 128.0M/76.4M
[OK] Key buffer hit rate: 98.6% (40M cached / 559K reads)





--------------enig8B848178DDF1B7C40DD967DF
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk+7fysACgkQhmBjz394AnlT4QCeNe01ei0CJ8fgLYspXSidndfq
WA8An35laoluxdCDj6HaXfSYQkKKigdV
=FBmX
-----END PGP SIGNATURE-----

--------------enig8B848178DDF1B7C40DD967DF--