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 <vegiv...@tuxera.be> 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 - mdyk...@gmail.com "May you live every day of your life." Jonathan Swift Larry's First Law of Language Redesign: Everyone wants the colon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org