List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:August 5 2004 7:31pm
Subject:Re: Why drop a index takes so long to do?
View as plain text  
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 only one) and re-write it to another file and
> then copy it back?

Yes.

> 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/
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