From: Johan De Meersman Date: November 9 2009 8:41am Subject: Re: DROP TABLE TOOK 39MIN List-Archive: http://lists.mysql.com/mysql/219294 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e6d78553574ccd0477ec2af8 --0016e6d78553574ccd0477ec2af8 Content-Type: text/plain; charset=ISO-8859-1 Presumably because you are removing 189 gigabyte of data and 549 gigabyte of indexes, all of which need to be marked as deleted in your innodb file. I/O is rather expensive :-) On MyISAM this would have been close to instantaneous (as you probably expected), because the datafile is used only for that table, so all that's needed is three filesystem delete operations. --0016e6d78553574ccd0477ec2af8--