But if you restart your mysql and then drop the table, It will take only 2 min to drop the table.
Thanks, Dilipkumar -----Original Message----- From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] Sent: Tuesday, November 10, 2009 12:04 AM To: Michael Dykman Cc: MySQL Subject: Re: DROP TABLE TOOK 39MIN Hi Michael, Already using innodb_file_per_table. Krishna On Mon, Nov 9, 2009 at 9:39 PM, Michael Dykman <mdyk...@gmail.com> wrote: > 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