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.

Reply via email to