From: Dan Nelson
Date: June 28 2002 10:10pm
Subject: Re: InnoDB made MyIsam DELETE's slow
List-Archive: http://lists.mysql.com/mysql/113371
Message-Id: <20020628221016.GA18990@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jun 29), Oleg said:
> Hello,
> 
> Our problem is that the speed of DELETE's became very slow after
> installing InnoDB.
> 
> For MyISAM, the table data file is just truncated to 0 after DELETE
> FROM table; isn't it? But it seems that system scans the whole table
> - and file is not truncating.
> 
> We have MySQL 3.23.48 running on FreeBSD 4.4 with LinuxThreads
> installed. May be it's because of LinuxThreads?

It's possible that because InnoDB tables have transaction support and
allow rollbacks of DELETE statements, the "DELETE FROM table"
optimization is turned off globally instead of just for InnoDB tables.
Try using "TRUNCATE TABLE" instead.

-- 
	Dan Nelson
	dnelson@stripped