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
his to?
> - my machine is dedicated to MySQL
> Thanks.
> Chris.
> -Original Message-
> From: Peter Zaitsev [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 11, 2004 2:03 PM
> To: Chris Fossenier
> Cc: 'MySQL List'
> Subject: Re: Indexing Woes
&
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
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. What type of data is being indexed? Are you attempting to index
while the database is being actively used? What version of MySQL are you
using?
10 matches
Mail list logo
