List:General Discussion« Previous MessageNext Message »
From:bowen Date:October 10 2006 3:27am
Subject:Why does mysql drop index very very slow in a large table?
View as plain text  
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 ?
Thread
• Why does mysql drop index very very slow in a large table?bowen10 Oct
  • RE: Why does mysql drop index very very slow in a large table?Chris \(GE Infra, Non-GE, US\) Wagner10 Oct
    • Re: Why does mysql drop index very very slow in a large table?Rolando Edwards10 Oct
      • Re: Why does mysql drop index very very slow in a large table?bowen11 Oct
        • Re: Why does mysql drop index very very slow in a large table?Rolando Edwards11 Oct