ay, June 30, 2008 4:52 PM
>To: 'Jerry Schwartz'; 'Ananda Kumar'
>Cc: 'mysql@lists.mysql.com'
>Subject: RE: Very large temporary file(s)
>
>Ananda, I tried your suggestion of adding "ORDER BY NULL" to the end of
>my query, but if anything it to
temporary space.
>-Original Message-
>From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, June 25, 2008 9:54 AM
>To: 'Ananda Kumar'
>Cc: mysql@lists.mysql.com
>Subject: RE: Very large temporary file(s)
>
>From: Ananda Kumar [mailto:[EMAIL PROTECTED]
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2008 10:55 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Very large temporary file(s)
True, if you explicitly use group by and order by, there would a group
operation after which sorting happens, but the
ailto:[EMAIL PROTECTED]
> *Sent:* Tuesday, June 24, 2008 10:50 PM
> *To:* Jerry Schwartz
> *Cc:* mysql@lists.mysql.com
> *Subject:* Re: Very large temporary file(s)
>
>
>
> In mysql, GROUP BY also by default does sorting using "ORDER BY", so you an
> avoid it by
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2008 10:50 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Very large temporary file(s)
In mysql, GROUP BY also by default does sorting using "ORDER BY", so you an
avoid it by including "ORDER
In mysql, GROUP BY also by default does sorting using "ORDER BY", so you an
avoid it by including "ORDER BY NULL" after GROUP BY, this should help.
On 6/24/08, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
>
> In all of that information, I forgot to post the actual query:
>
> INSERT INTO consolidated
In all of that information, I forgot to post the actual query:
INSERT INTO consolidated_customer_data
SELECT
customers.customer_id,
account.account_name,
customers.email,
customers.email_status,
customers.dm_status,
customers.status,
cus
Double nuts! I corrected the wrong number. This time, I am reading my
message more carefully. The temporary space used is indeed 800 MEGABYTES!
I still need help, though.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
--
MySQ
Nuts: not only did I write a huge message, but I made a booboo up at the
top! I won't repost the whole thing.
>I'm running MySQL 4.1.22-standard Community on CentOS. My problem is a
>query
>that is using about 800mb for what I assume is a temporary sort file,
[JS] That should be 800Gb.
--
MyS
I'm running MySQL 4.1.22-standard Community on CentOS. My problem is a query
that is using about 800mb for what I assume is a temporary sort file, and
I'm hoping that I can do something about it.
The purpose of this query is to populate an unnormalized table with data
from several other tables. I
10 matches
Mail list logo
