From: Reindl Harald
Date: May 22 2012 12:09pm
Subject: Re: Reducing ibdata1 file size
List-Archive: http://lists.mysql.com/mysql/227499
Message-Id: <4FBB81DE.8080804@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigCA28F3B8D5B54856F21E22F8"

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



Am 22.05.2012 13:59, schrieb Johan De Meersman:
> ----- Original Message -----
>> From: "Reindl Harald" <h.reindl@stripped>
>>
>> 95% of mysqld-installations have no problem with
>> innodb_file_per_table so DEFAULTS should not be for 5%
>=20
> There is "no problem", and there is "better practice"=20
> and if your system is I/O bound it makes sense to minimize on-disk frag=
mentation.

many systems are not CPU-bound nor IO-bound because they
are well designed for their load

> However, given the need for file-per-table to benefit from compression
> I admit that it might make sense to change the default now.=20

yes, one reason more

> Would you say compression should be enabled by default, too?=20

no because with sane defaults (file_per_table) you can do
this with one command, with the current defaults only
with many work and downtime to switch

> If you're aiming at diskbound systems, I'd think that it might make sen=
se, too

no, defaults should be as flexible as possible and not
optimized for special workloads

>> it is a surprising behavior and defaults should minimize surprises
>=20
> Changing the default is a surprise, no? :-)=20

no problem in a minor update
5.5.0 was a good moment
5.6.0 is the next good one

> Also, everything is a surprise if you don't read the fine manual

please do not tell us that you have seen any single option
of any software you are using BEFORE beause your systems
would still be in theoretical stages

a default causing the user to dump out all his data, switch
it and pray while re-import is running and system is down
is a worst-case default


--------------enigCA28F3B8D5B54856F21E22F8
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+7gd4ACgkQhmBjz394AnkFbQCeId1fjBJgAn4mzKOLyoZft2Q7
O28An2u9VoqA+SDEzK9S/2x9dCeUG536
=7Srs
-----END PGP SIGNATURE-----

--------------enigCA28F3B8D5B54856F21E22F8--