logo       

InnoDB made MyIsam DELETE's slow: msg#01114

db.mysql.general

Subject: InnoDB made MyIsam DELETE's slow

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


---------------------------------------------------------------------
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-thread113363@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise