nothing over 20mill for records.
Chris.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 5:47 PM
To: Chris Fossenier
Cc: 'Peter Zaitsev'; 'MySQL List'
Subject: RE: Indexing Woes
These files will be created in the /tm
;<<<<<<<<<<
On 2/11/04, 5:42:31 PM, Chris Fossenier <[EMAIL PROTECTED]> wrote
regarding RE: Indexing Woes:
> None of my individual tables are larger than 12GB, however, I have no
idea
> if MySQL creates a separate TMP file for each indexing
] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 5:13 PM
To: Chris Fossenier
Cc: 'Peter Zaitsev'; 'MySQL List'
Subject: RE: Indexing Woes
If I am reading your parameter correctly, MySQL will limit the size of
the temporary file created to 30GB. If the file exce
;>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/11/04, 4:54:21 PM, Chris Fossenier <[EMAIL PROTECTED]> wrote
regarding RE: Indexing Woes:
> Can you provide a better explanation of these variables? I have yet to
find
>
al Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 4:50 PM
To: Chris Fossenier
Cc: 'Peter Zaitsev'; 'MySQL List'
Subject: RE: Indexing Woes
Performing your indexing in one batch will create a temp table only once
as opposed t
lt;<<<<<<
On 2/11/04, 2:53:34 PM, Chris Fossenier <[EMAIL PROTECTED]> wrote
regarding RE: Indexing Woes:
> I have checked these...but I don't know what to set them too. Can I get
more
> input? Should I only run 1 index at a time? I have 2 machines (both quad
&g
27;
Subject: Re: Indexing Woes
On Wed, 2004-02-11 at 09:29, Chris Fossenier wrote:
> Hello,
>
> I had a question about indexing a while back and everyone screamed
> "normalize"!!
>
> Well...I've normalized much as I'm going to, and at most I have 3
> index
lto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 12:10 PM
To: Chris Fossenier
Cc: 'MySQL List'
Subject: Re: Indexing Woes
Yes a duplicate copy of the table is created and the Indexes are created
on that new table, the original table is dropped and the new table is
renamed.
On Wed, 2004-02-11 at 09:29, Chris Fossenier wrote:
> Hello,
>
> I had a question about indexing a while back and everyone screamed
> "normalize"!!
>
> Well...I've normalized much as I'm going to, and at most I have 3 indexes on
> any one table. My database has 120 million records in it and the
?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/11/04, 11:29:44 AM, Chris Fossenier <[EMAIL PROTECTED]> wrote
regarding Indexing Woes:
> Hello,
> I had a questi
Hello,
I had a question about indexing a while back and everyone screamed
"normalize"!!
Well...I've normalized much as I'm going to, and at most I have 3 indexes on
any one table. My database has 120 million records in it and the index
creation is taking a ridiculous amount of time. I can creat
11 matches
Mail list logo
