From: Reindl Harald
Date: October 29 2012 1:55pm
Subject: Re: optimize and tmpfiles
List-Archive: http://lists.mysql.com/mysql/228517
Message-Id: <508E8AE0.8030405@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigE6A31296FFEF9C2C93466778"

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



Am 29.10.2012 14:54, schrieb walter harms:
>=20
>=20
> Am 29.10.2012 13:17, schrieb Reindl Harald:
>>
>>
>> Am 29.10.2012 12:48, schrieb walter harms:
>>> hi list,
>>> does someone know under what circumstances ''optimize tables'' will
>>> create a tmpfile?
>>
>> under all if it is MyISAM and for "select id from table order by rand(=
);" too
>>
>=20
> interessting, i was trying to force it (with optimize) but it did not w=
ork.
>=20
> Is there a way to restrict the maximum size of those tmpfiles?

you do you imagine restrict them?
they are as big as the table


--------------enigE6A31296FFEF9C2C93466778
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/

iEYEARECAAYFAlCOiuAACgkQhmBjz394Anl3gwCfeMgTsm5dzfUSGSEmtpqqDF2S
vrwAoIkBoRVKeEBauIaA9Ju5/dtaSfiY
=KFs6
-----END PGP SIGNATURE-----

--------------enigE6A31296FFEF9C2C93466778--