***BOGO*** Re: Huge temporary file

[rajlist@xxxxxxxxxxxxxx]

In infinite wisdom "Jerry Schwartz" <jschwartz@xxxxxxxxxxxxxxxx> spoke thus:
> I'm at a loss as to why, other than that I must have hit
> some threshold. If anyone can tell me what I need to change in my
> configuration, I'd appreciate it.

MySQL creates the tmp tables in memory if the size of the table matches
these thresholds 
max_heap_table_size
tmp_table_size

Whichever of these two values is smaller is the one that applies.

Is the datatype of consolidated_customer_data.stage_name varchar(15)?

(There are other conditions too, but since you can fit the table by
removing one column, I am assuming you are hitting size threshold
<http://dev.mysql.com/doc/refman/5.0/en/internal-temporary-tables.html>) 

-- 
raj shekhar
facts: http://rajshekhar.net
opinions: http://rajshekhar.net/blog
I've never made anyone's life easier and you know it!



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx