List:General Discussion« Previous MessageNext Message »
From:Haitao Jiang Date:August 5 2004 6:27pm
Subject:Why drop a index takes so long to do?
View as plain text  
Hi,

I have a 3GB index which includes a fulltext index on 2 columns. I
wanted to drop this fulltext index from the table, but it took
forever. Why it is so slow? Is it because MySQL basically go through
the index file (there is only one) and re-write it to another file and
then copy it back?

Any other fast way to drop a index like this?

Thanks

Haitao
Thread
Why drop a index takes so long to do?Haitao Jiang5 Aug
  • Re: Why drop a index takes so long to do?mos5 Aug
  • Re: Why drop a index takes so long to do?Jeremy Zawodny5 Aug
    • Re: Why drop a index takes so long to do?Dan Nelson5 Aug