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

[Wagner, Chris \(GE Infra, Non-GE, US\)]

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.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]