In infinite wisdom "Jerry Schwartz" <jschwartz@stripped> 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!
