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! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]