List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:November 9 2009 8:41am
Subject:Re: DROP TABLE TOOK 39MIN
View as plain text  
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.

Thread
DROP TABLE TOOK 39MINKrishna Chandra Prajapati9 Nov
  • Re: DROP TABLE TOOK 39MINJohan De Meersman9 Nov
    • Re: DROP TABLE TOOK 39MINMichael Dykman9 Nov
      • Re: DROP TABLE TOOK 39MINKrishna Chandra Prajapati9 Nov
        • RE: DROP TABLE TOOK 39MINDilip Kumar Parikh10 Nov
          • Re: DROP TABLE TOOK 39MINJohan De Meersman10 Nov