List:General Discussion« Previous MessageNext Message »
From:Oleg Date:June 28 2002 9:01pm
Subject:InnoDB made MyIsam DELETE's slow
View as plain text  
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?

Thank you,
Dino

Thread
InnoDB made MyIsam DELETE's slowOleg28 Jun
  • Re: InnoDB made MyIsam DELETE's slowDan Nelson29 Jun