From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 27, 2008 1:58 AM
To: Jerry Schwartz
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Huge temporary file
do,
show varaibles like '%tmp%'.
show variables like '%tmp%';
| tmpdir
On 8/26/08, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
>
> >-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
>-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]>
From: Johnny Withers [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 9:37 AM
To: Jerry Schwartz
Subject: Re: Huge temporary file
You are using the defaults then, I'm not sure what they are, but you can
view the location of the temp directory (probably /tmp) and the maximum si
>-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]&g
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 12:09 AM
To: Jerry Schwartz
Cc: mysql
Subject: Re: Huge temporary file
what is the value for tmpdir parameter in you my.cnf.
[JS] I don't have one. The /tmp file system is what is being consumed. I
should add
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 mat
what is the value for tmpdir parameter in you my.cnf.
regards
anandkl
On 8/26/08, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
>
> Awhile back I was having trouble with an INSERT ... SELECT taking up an
> enormous amount of temporary file space. I've narrowed down, in fact
> eliminated, my problem