innodb: TRUNCATE vs. DELETE FROM

2004-12-06 Thread Paul Mallach
Hi! Is TRUNCATE optimized for innodb tables in MySQL 4.1.7? http://dev.mysql.com/doc/mysql/en/TRUNCATE.html says: For InnoDB, TRUNCATE TABLE is mapped to DELETE, so there is no difference.. But http://dev.mysql.com/doc/mysql/en/InnoDB_tuning.html claims: Beware also of other big disk-bound

Re: innodb: TRUNCATE vs. DELETE FROM

2004-12-06 Thread Heikki Tuuri
Paul, - Original Message - From: Paul Mallach [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, December 06, 2004 4:26 PM Subject: innodb: TRUNCATE vs. DELETE FROM Hi! Is TRUNCATE optimized for innodb tables in MySQL 4.1.7? http://dev.mysql.com/doc/mysql/en