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

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



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


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

iEYEARECAAYFAlCOc9oACgkQhmBjz394AnmWrgCeJtvVsrfZUg4j6orf0iZogIzx
RI8AniliwBjdruWVLND81DEwgSbumHr0
=9HPa
-----END PGP SIGNATURE-----

--------------enig36B99EA4C4041015407BAE0E--