From: Reindl Harald
Date: October 24 2011 3:34pm
Subject: Re: large temp files created by mysql
List-Archive: http://lists.mysql.com/mysql/226166
Message-Id: <4EA58582.6010004@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig937C3C91C60DF5A2B13FCC17"

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

select id from table order by rand() limit 1;
is doing as example a dumb temporary table with the full size

Am 24.10.2011 17:03, schrieb Joey L:

On Mon, Oct 24, 2011 at 10:52 AM, Joey L <mjh2000@stripped> wrote:

> I have a very large table - approx 3 or 4 gig in size.
> When i initiate a process on my webpage - mysql starts to create a
> temporary table in /tmp directory.
> Is there a way i can create this file/table ahead of time so mysql
> does not have to create it ?
>
> thanks
> mjh
>
Sorry - it is 30 gig file .



--=20

Mit besten Gr=FC=DFen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofm=FChlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/

http://www.thelounge.net/signature.asc.what.htm



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

iEYEARECAAYFAk6lhYIACgkQhmBjz394AnmeYQCfarfm+ogX5efoucYmxdlmI4F0
dasAn2SsbZDmwe2+xSXMumA2OiN1K0Xi
=Cfzn
-----END PGP SIGNATURE-----

--------------enig937C3C91C60DF5A2B13FCC17--