[thelist] Updating a BIG table with a few indexes...

Matt Warden mwarden at gmail.com
Wed Sep 5 13:49:05 CDT 2007

On 9/5/07, Tris <beertastic at gmail.com> wrote:
> ALTER TABLE table1 ADD INDEX (fieldName), ADDINDEX (fieldName) .........
> with 8 million records...

Try CREATE INDEX syntax instead, or at least try separate alters. Only
thing I can think of is that you are running into I/O issues, or your
database size is growing so fast that it must  pause to allocate new
space, which will take time each time. Still, though, it should never
take 9+ hours. 8 million records should be a piece of cake. 1 hr tops.

Matt Warden
Cincinnati, OH, USA

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list