John Nagle wrote:

> I loaded about 15 million records into a MySQL table, and
> then did an ALTER TABLE to add an index on a BIGINT field.
> The ALTER TABLE has been running for about 30 hours now.
> About how long should that take?


I would say 3-20 minutes depending on the hardware, so long as box is doing
nothing else.

What does SHOW PROCESSLIST say?


--
Brian Wakem
Email: http://homepage.ntlworld.com/b.wakem/myemail.png