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 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?
Not that I know of.
Someday each index will be in a separate file (optionally?). Then
it'sll be quite fast to drop an index.
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
[book] High Performance MySQL -- http://highperformancemysql.com/