Re: DROP TABLE TOOK 39MIN

[Johan De Meersman]

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.