Re: InnoDB made MyIsam DELETE's slow

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@xxxxxxxxxxxxxxx

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread113371@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php