List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:October 24 2011 3:34pm
Subject:Re: large temp files created by mysql
View as plain text  
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 .



-- 

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



Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
large temp files created by mysqlJoey L24 Oct
  • Re: large temp files created by mysqlJoey L24 Oct
    • Re: large temp files created by mysqlReindl Harald24 Oct
      • Re: large temp files created by mysqlmos24 Oct
        • Re: large temp files created by mysqlJoey L24 Oct
          • Re: large temp files created by mysqlReindl Harald24 Oct
        • Re: large temp files created by mysqlReindl Harald24 Oct
          • Re: large temp files created by mysqlmos24 Oct
            • Re: large temp files created by mysqlReindl Harald25 Oct
              • Re: large temp files created by mysqlmos25 Oct
                • Re: large temp files created by mysqlReindl Harald25 Oct
                  • Re: large temp files created by mysqlmos26 Oct
                    • Re: large temp files created by mysqlReindl Harald26 Oct
Re: large temp files created by mysqlAntony T Curtis24 Oct
  • Re: large temp files created by mysqlJoey L24 Oct
    • Re: large temp files created by mysqlJohan De Meersman24 Oct
Re: large temp files created by mysqlJan Steinman31 Oct
  • Re: large temp files created by mysqlJan Steinman31 Oct
    • Re: large temp files created by mysqlLuis Daniel Lucio Quiroz24 May
      • RE: large temp files created by mysqlRick James24 May
        • RE: large temp files created by mysqlLuis Daniel Lucio Quiroz24 May