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 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'll be quite fast to drop an index.
Even with the current setup, index changes could be sped up by simply
copying the index blocks for the rest of the indices instead of
rebuilding them. Dropping could even be made instantaneous, resulting
in freespace in the index file that can be reused or defragmented with
OPTIMIZE TABLE.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
