Page 1 of 1

indexes

Posted: Wed Oct 18, 2006 4:48 pm
by s.dot
I am creating an index on an INT (10) field in a table that has only 88,000 records. So far this has taken over an hour!

Has something gone wrong, should I kill mysqld?

Posted: Wed Oct 18, 2006 4:52 pm
by Christopher
Yes. It sounds like the server had died.

Posted: Wed Oct 18, 2006 5:01 pm
by s.dot
Killed it. The query had completed. ........ wonder how much of that hour i just wasted. =/

Thanks!