: 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
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
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
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
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