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 <mjh2...@gmail.com> 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 . -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 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
signature.asc
Description: OpenPGP digital signature
