>-----Original Message----- >From: news [mailto:[EMAIL PROTECTED] On Behalf Of >[EMAIL PROTECTED] >Sent: Tuesday, August 26, 2008 2:36 AM >To: mysql@lists.mysql.com >Subject: Re: Huge temporary file > >In infinite wisdom "Jerry Schwartz" <[EMAIL PROTECTED]> spoke >thus: [JS] My wisdom use to be infinite, but infinity has gotten bigger since I was a teenager.
>> 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. > [JS] I presume that I should set these to something above the default, then, since it is "real" file space that is being consumed. Our database is small, so I've never had to give much thought to tuning. >Is the datatype of consolidated_customer_data.stage_name varchar(15)? > [JS] It was, yes. Most of the other fields were varchar as well, with the exception of one text field. >(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>) > [JS] I'll read that article and see if it applies. Thanks. >-- >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] >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
