Something you're doing is creating a very large temporary table as
part of handling it's query. Usual culprit would be something doing a
full table join combined with an "order by" or "group by" which would
typically cause MySQL to need to create a temp table.
You should do EXPLAINs on your slow-running queries to find out which
ones are likely... If it is generating a 30gig file, I'd expect it
must be a very slow query.
Regards
Antony,
On 24 Oct 2011, at 08:03, Joey L wrote:
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 .
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=antony.cur...@ieee.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org