From: Reindl Harald
Date: October 29 2012 5:14pm
Subject: Re: optimize and tmpfiles
List-Archive: http://lists.mysql.com/mysql/228520
Message-Id: <508EB97C.5040108@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature";
boundary="------------enigF85ACA0503B631A453512EA7"
--------------enigF85ACA0503B631A453512EA7
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Am 29.10.2012 18:11, schrieb walter harms:
>>> Is there a way to restrict the maximum size of those tmpfiles?
>>
>> you do you imagine restrict them?
>=20
> actually i espected a no, but sometimes i have to think positv.
think negative and get positive suprprised :-)
>> they are as big as the table
> that is a problem with a large table
that is why you should always have as minimum space left
as the largets table grows because you need 'optimize table'
and in the worst case the full size to free disk-space after
deleting many data or for whatever repair
--------------enigF85ACA0503B631A453512EA7
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://www.enigmail.net/
iEYEARECAAYFAlCOuXwACgkQhmBjz394AnkS3ACfcW9SZRJHzdMP44PPx5mkI4uS
XbIAnRx9hvDPronH1Hg73k8DCybKaA44
=0ktH
-----END PGP SIGNATURE-----
--------------enigF85ACA0503B631A453512EA7--