From: Michael Dykman
Date: November 9 2009 4:09pm
Subject: Re: DROP TABLE TOOK 39MIN
List-Archive: http://lists.mysql.com/mysql/219299
Message-Id: <814b9a820911090809p4513aee3v8e29e6e112b1c5c3@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1

Under InnoDb, you could use file-per-table which would have
significantly reduced the inter-dependencies..  given the large data
size and heavy I/O you report, it might be a wise way to go.

 - michael dykman


On Mon, Nov 9, 2009 at 3:41 AM, Johan De Meersman <vegivamp@stripped> wrote:
> 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.
>



-- 
 - michael dykman
 - mdykman@stripped

"May you live every day of your life."
    Jonathan Swift

Larry's First Law of Language Redesign: Everyone wants the colon.