From: Reindl Harald
Date: November 30 2011 12:58am
Subject: Re: help needed restoring crashed mysql
List-Archive: http://lists.mysql.com/mysql/226390
Message-Id: <4ED57FA2.7060409@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigC431892AC943202A6AA430E7"

--------------enigC431892AC943202A6AA430E7
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 30.11.2011 01:11, schrieb Karen Abgarian:
>> MY only luck is that i recognized this years ago after PLAYING
>> with innodb and so i started with "innodb_file_per_table=3D1" from
>> the begin with the first production database
>=20
> Well, I would not base my database design on luck and playing.   There =
should be good awareness=20
> of what the features do and what would be the plan to deal with file al=
locations should the database
> grow, shrink or somerset

if you are working many years with mysql and myisam you
normally do not expect this - and no my work depends never
really on luck and that is why it look in ALL datadirs of
all software i am using and missed the table files known
from my isam

most peopole DO NOT care about this and not expect that
allocated space will not be freed nor makes it any sense
to have a whole database-server to dump/import because
you get rid of big databases

> Another piece of logic is that it is not really typical for the databas=
es
> to lose 50% of its volume.

well, so install http://www.dbmail.org/ with replication and offsite-back=
ups
of the slave, get rid of your biggest mail-user and think about how usefu=
l
it is to waste all this space as before multiple times in the backup-stor=
ages

it did never happen to me - but i heard so many people start whining beca=
use
the mysql-defaults and these are most pepole which do not have our knowle=
dge
to handle this before and in this case also not able to handle dump/impor=
t
in a production environment


--------------enigC431892AC943202A6AA430E7
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.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk7Vf6IACgkQhmBjz394AnnRagCeNhKfLUPxFrTi6n5ovbDfVRPR
NFAAn0b/hwBqYmqZLc4Sgl2vLyz485yH
=rw4L
-----END PGP SIGNATURE-----

--------------enigC431892AC943202A6AA430E7--