From: Date: October 10 2006 5:27am
Subject: Why does mysql drop index very very slow in a large table?
List-Archive: http://lists.mysql.com/mysql/202477
Message-Id: <625ccb870610092027p3a48e308i266ec48a1dfa484e@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Why does mysql drop index very very slow in a large table?

I have a large table with more than 5M rows, and many indexes. Now I
want to drop some of them. But it seems that mysql can not handle this
very well. It takes a very long time (more than half an hour) to do ,
and make me unbearable.

And I found a mysql bug here. But don't know its current status.

http://bugs.mysql.com/bug.php?id=2364

Anybody know this ?