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

["Ananda Kumar" <anandkl@xxxxxxxxx>]

do,

show varaibles like '%tmp%'.

show variables like '%tmp%';
| tmpdir            | /tmp/

This is case of your tmp file system, running out space.
You can change this parameter to a different file system having more space,
and then your job should run fine.

regards
anandkl


On 8/26/08, Jerry Schwartz <jschwartz@xxxxxxxxxxxxxxxx> wrote:
>
> >-----Original Message-----
> >From: news [mailto:news@xxxxxxxxxxxxx] On Behalf Of
> >rajlist@xxxxxxxxxxxxxx
> >Sent: Tuesday, August 26, 2008 2:36 AM
> >To: mysql@xxxxxxxxxxxxxxx
> >Subject: Re: Huge temporary file
> >
> >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>)
> >
> [JS] According to that article, it is the presence of a TEXT field that is
> forcing the use of a temporary table. The JOIN to the `stage` table must
> have been causing the temporary table to disk.
>
> That doesn't explain why the without the `stage` table, the temporary table
> fits in the (default) heap size of 16777216 and (default) tmp_table_size of
> 33554432; but with the `stage` table MySQL needs more than 973M.
>
> I might have to just give up on this and put it in the X file.
> >--
> >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=jschwartz@the-
> >infoshop.com
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=anandkl@xxxxxxxxx
>
>