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

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



Am 22.05.2012 13:40, schrieb Johan De Meersman:
> ----- Original Message -----
>> From: "Reindl Harald" <h.reindl@stripped>
>> Subject: Re: Reducing ibdata1 file size
>>
>> well but for what price?
>> the problem is the DEFAULT
>>
>> users with enough knowledge could easy change the default
>> currently what is happening is that mostly every beginner
>> is caught in the trap with single-table-space and hearing
>> from "innodb_file_per_table" after is is way too late
>=20
> All true, but I would argue that enterprise-suitable defaults are a goo=
d thing=20
> shame so many of the other defaults aren't :-)

95% of mysqld-installations have no problem with innodb_file_per_table
so DEFAULTS should not be for 5%

and as said in another reply to this thread you
need "innodb_file_per_table" for compression and
no, most servers these days are NOT cpu-bound

most are IO-bound especially in enterprise environments
with shared storage (SAN)

> And yes, it is problematic for beginners, but so is having beginners=20
> manage production sites, isn't it?

not only for beginners

very few people expecting that a datastorage is only growing and growing
with no painless way to release all the wasted space if you make tests
with real big data and drop them

this has nothing to do with "enterprise" or "beginners"

it is a surprising behavior and defaults should minimize surprises


--------------enig0B43A78F5DE67E924FC78DD3
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+7fKoACgkQhmBjz394AnlNUwCfZbSJCHNZ725myy2jb9YQkQTm
x24AninQ/kVyU7pNrnM2njTU32aHkvbb
=rUFE
-----END PGP SIGNATURE-----

--------------enig0B43A78F5DE67E924FC78DD3--