From: Date: October 10 2006 8:53am
Subject: RE: Why does mysql drop index very very slow in a large table?
List-Archive: http://lists.mysql.com/mysql/202483
Message-Id: <F79D46534E28DD4FBD21180CF14A9D6F1AAD5D@CINMLVEM15.e2k.ad.ge.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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.