List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:June 28 2002 10:10pm
Subject:Re: InnoDB made MyIsam DELETE's slow
View as plain text  
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
Thread
InnoDB made MyIsam DELETE's slowOleg28 Jun
  • Re: InnoDB made MyIsam DELETE's slowDan Nelson29 Jun