Use Alter table Disable Keys, before loading the Data to your system,
and then Alter table enable keys,
This way you wont have to recreate your indexes
-Original Message-
From: Ananth Reddy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 10:08 PM
To: [EMAIL PROTECTED]
David Griffiths wrote:
I was wondering what the bottleneck was. I'm adding a dozen indexes to
the same large-ish InnoDB table. Each successive index takes a bit
longer (45 seconds or so on a dual P3-933 with 2 gig of RAM).
Every time you add a new index or do any non-trivial modification to the
.
- Original Message -
From: Sasha Pachev [EMAIL PROTECTED]
To: David Griffiths [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 20, 2004 8:41 AM
Subject: Re: Speeding up index creation under InnoDB
David Griffiths wrote:
I was wondering what the bottleneck was. I'm