In infinite wisdom "Jerry Schwartz" <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
