I’ve a BIG table of 80.000.000 record (quite 30GByte of data and 7GByte of index).
I need to do some alter table. Before do that I make a DISABLE KEYS and when I finish all ALTER TABLE i make a ENABLE KEYS on the tables.
My alters table are simply ADD 3 INDEX and 2 FIELDs…
I use a Intel Core 2 DUO with 2GHz and 3G of RAM on a 400GByte IDE disk at 10k rounds…
All this operations have take 4 Days… is normal ???