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