| 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 Jiang | 5 Aug |
| • Re: Why drop a index takes so long to do? | mos | 5 Aug |
| • Re: Why drop a index takes so long to do? | Jeremy Zawodny | 5 Aug |
| • Re: Why drop a index takes so long to do? | Dan Nelson | 5 Aug |
