]
Subject: Speeding up index creation
We have MyISAM table with 150 million rows. The data is being laoded
from other system.
When I load data without indices, it is fast (30 minutes) but creating
index is taking 15 hours.
Load data with indices is taking 30 hours (worse than the other option)
I am
We have MyISAM table with 150 million rows. The data is being laoded from other system.
When I load data without indices, it is fast (30 minutes) but creating index is taking
15 hours.
Load data with indices is taking 30 hours (worse than the other option)
I am wondering if there is a way to spee
David.
- 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
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 sch
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).
Is it disk additional tables-space management that is taking the extra
time? Would faster disks h
