List:General Discussion« Previous MessageNext Message »
From:Chris \(GE Infra, Non-GE, US\) Wagner Date:October 10 2006 6:53am
Subject:RE: Why does mysql drop index very very slow in a large table?
View as plain text  
A workaround is to use mysqlhotcopy to snapshot the table and also only copy the header to
the MYI file.  Then delete the original and rename the copy back to the original.  This
will effectively drop all indexes and should take no more time than what the disk takes
to copy the .my* files.



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