Why drop a index takes so long to do?

2004-08-05 Thread Haitao Jiang
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

Re: Why drop a index takes so long to do?

2004-08-05 Thread mos
At 01:27 PM 8/5/2004, you wrote: 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

Re: Why drop a index takes so long to do?

2004-08-05 Thread Jeremy Zawodny
On Thu, Aug 05, 2004 at 11:27:40AM -0700, Haitao Jiang wrote: 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

Re: Why drop a index takes so long to do?

2004-08-05 Thread Dan Nelson
In the last episode (Aug 05), Jeremy Zawodny said: On Thu, Aug 05, 2004 at 11:27:40AM -0700, Haitao Jiang wrote: 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