1

I'm trying to just drop a 500mb fulltext index on an older 4.1 MySQL MyISAM table.

When I do it, the cpu pegs to 100% and sits like that for over 10 minutes.

This cannot be normal, right? I gave up and just restarted mysql and index is still there.

There is no message in the error log.

Any other approach I can try?

Nevermind, it took 30 minutes and double the database size in free disk space in the end.

I guess even drop is very slow for some reason (I know building can be, but drop?)

ck_
  • 459
  • 1
  • 7
  • 20

1 Answers1

1

This is a very old bug in mysql: http://bugs.mysql.com/bug.php?id=2364

Aaron
  • 2,968
  • 1
  • 23
  • 36